Help:Index performance issue

From: <u518615722_at_spawnkill.ip-mobilphone.net>
Date: Tue, 22 May 2001 17:59:03 GMT
Message-ID: <l.990554346.1418609619_at_[198.138.198.252]>


We have a table with 13 indexes built
[Quoted] 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/new
Received on Tue May 22 2001 - 19:59:03 CEST

Original text of this message