Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Extents, Index, Optimization Q's
Len wrote:
> 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
My impression of what you are saying is that the problem has nothing to do with Oracle. And that definitely, even if it did, you are looking in the wrong places.
You need to check out and benchmark your SQL using EXPLAIN PLAN in Oracle to see if it is using the indexes you created.
But far more importantly ... before posting here again you need to provide information specific to this situation so we can help you.
At this point my bet is bad VB code.
Daniel Morgan Received on Wed Sep 25 2002 - 18:28:00 CDT
![]() |
![]() |