tuning question

From: Vissu <vissuyk_at_yahoo.com>
Date: 17 Dec 2001 16:23:34 -0800
Message-ID: <2bedd6a7.0112171623.24bbd4be_at_posting.google.com>


Hi,
I have a query that looks like below :

SELECT
posting_date,
...
...

from XYZ
WHERE
id = 'xx'
and posting_date <= 'some date'
and posting_date >= 'some other date'
and objectname = 'foo'
and (col1 = 'bla' or col2 = 'bla' or col3 = 'bla');

When the autotarce is set to trace with timing on, it showed 5432 millisecs. There are several million rows in the table XYZ and there are bunch of indexes and the execution plan does show that it is making use of an index and it is using index rowid to access the table.

How to speed up queries that have predicates of different types and also operators of different types. What I mean is I have predicates of type varchar2, varchar2(1), date ..etc and the operators are : <=, >=, =, or etc

The question really is how to create an efficient index over different type of fields ?

Thanks for any help. BTW I am using Oracle 805.

Vissu Received on Tue Dec 18 2001 - 01:23:34 CET

Original text of this message