Re: How to get query to use an index

Hi Christian,

Because there's an OR in the WHERE clause. It simply doesn't work.

Currently. May be some future release brings something like skip - range index scan:)




What about index fast full scan?

Jaromir
----- Original Message ----- From: "Christian Antognini" <Christian.Antognini@xxxxxxxxxxxx>
To: <paulastankus@xxxxxxxxx>
Cc: "oracle-l" <oracle-l@xxxxxxxxxxxxx>
Sent: Wednesday, April 12, 2006 7:22 AM
Subject: RE: How to get query to use an index



Paula

Why not consider using a concatenated index with
both columns versus writing the SQL statement as a
Union All

Because there's an OR in the WHERE clause. It simply doesn't work.


HTH Chris -- http://www.freelists.org/webpage/oracle-l





--
http://www.freelists.org/webpage/oracle-l


Other related posts: