Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Extents, Index, Optimization Q's

Extents, Index, Optimization Q's

From: Len <dsilvalen_at_netscape.net>
Date: 25 Sep 2002 14:16:44 -0700
Message-ID: <c5a39ae0.0209251316.4568667e@posting.google.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US