Extents, Index, Optimization Q's

I have a VB application that opens and accesses an Oracle DB. The routine iterates through records at glacial speeds.

I indexed the 22 tables that are opened read and closed, that helped marginally.
All tables have unique indexes, some one mentioned Primary indexing is more efficient, is that true?

After only experiencing marginal improvements I tried reducing the extents on the tables, marginal improvement but nothing colossal.

Does anyone have recommendations to improve the speed of my application by tweaking the way data is stored in the Oracle 8 DB?

Thanking you in a advance,
Len Received on Wed Sep 25 2002 - 16:16:44 CDT