|
[oracle-l]
||
[Date Prev]
[02-2008 Date Index]
[Date Next]
||
[Thread Prev]
[02-2008 Thread Index]
[Thread Next]
Re: Queries vs Indexes and the 10053
- From: "Don Seiler" <don@xxxxxxxxx>
- To: oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 1 Feb 2008 13:53:45 -0600
Just an addendum that the desired index is LOCAL. The table (and
index) has 7 partitions, each with 18 subpartitions.
Don.
On Feb 1, 2008 11:29 AM, Don Seiler <don@xxxxxxxxx> wrote:
> Table FOO is partitioned by col4 monthly, and then subpartitioned by
> hash on another varchar2 field not used in this query. I also have an
> index on all fields in the predicate, but the order is (col1, col3,
> col2, col4). col1, col2, and col3 are varchar2, col4 is a date
> (obviously).
--
Don Seiler
http://seilerwerks.wordpress.com
ultimate: http://www.mufc.us
--
http://www.freelists.org/webpage/oracle-l
|
|
