Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Help:Index performance issue
We have a table with 13 indexes built
on it. We have one sql statement runing
against it.
When we run explain plan for it, there is
no full table scan, which means the sql
does not have any problem, right?
Where else could we do to improve the
performance? I am thinking keep some
index in the keep_pool, but how do you
select which index to keep in the keep_pool?
The first one that is used?
Any suggestions? Thanks
-- Sent by dbadba62 from hotmail within area com This is a spam protected message. Please answer with reference header. Posted via http://www.usenet-replayer.com/cgi/content/newReceived on Tue May 22 2001 - 12:59:03 CDT