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_at_trivadis.com> To: <paulastankus_at_yahoo.com>
Cc: "oracle-l" <oracle-l_at_freelists.org>
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