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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts: