Re: How to get query to use an index

  • From: "jaromir nemec" <jaromir@xxxxxxxxxxxx>
  • To: <Christian.Antognini@xxxxxxxxxxxx>, <paulastankus@xxxxxxxxx>
  • Date: Thu, 13 Apr 2006 08:21:47 +0200

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: