Message-
Sent: 31 May 2001 18:22
To: Multiple recipients of list ORACLE-L
Oracle could be doing partition elimination but the tools that you are using
to see the execution plan is not showing you the details you're looking for.
I usually do:
Truncate table plan_table;
explain plan for your-sql
the partition(s) effected by the where
condition?.
The Oracle documentation gives a good insight into partitioning but does not
go into detail about when partition elimination will be performed and what
the explain plan would look like when this occurs. If anyone can point me
to a section
Dave:
Oracle does do partition elimination in this case...check out he
partition_start and partition_stop columns of you plan_table.
Kevin
-Original Message-
Sent: Thursday, May 31, 2001 12:01 PM
To: Multiple recipients of list ORACLE-L
Hi All,
Can anyone help me with this.
I have
Oracle could be doing partition elimination but the tools that you are using
to see the execution plan is not showing you the details you're looking for.
I usually do:
Truncate table plan_table;
explain plan for your-sql;
select * from plan_table;
There should be two columns that indicate
to only scan the partition(s) effected by the where
condition?.
The Oracle documentation gives a good insight into partitioning but does not
go into detail about when partition elimination will be performed and what
the explain plan would look like when this occurs. If anyone can point me
to a section
Yes it does.
The scan will be range of partitions and the execution plan will show
partition stop = key and partition start = key.
Regards,
Waleed
-Original Message-
Sent: Thursday, May 31, 2001 3:17 PM
To: Multiple recipients of list ORACLE-L
Can oracle do partition elimination
Can oracle do partition elimination when ysing bind variables?
Alex Hillman
-Original Message-
Sent: Thursday, May 31, 2001 1:16 PM
To: Multiple recipients of list ORACLE-L
Dave:
Oracle does do partition elimination in this case...check out he
partition_start and partition_stop
At parse time, the optimizer determines that partition elimination can be
done -- which partitions to use is determined after the values are bound to
the query.
-Original Message-
Sent: Thursday, May 31, 2001 3:17 PM
To: Multiple recipients of list ORACLE-L
Can oracle do partition
The docs actually do a good job of showing what the explain plan
will look like for a partition elimination.
Look at the 'Explan Plan' chapter of 'Designing and Tuning for Performance'
Are you using ?/rdbms/admin/utlxplp.sql to examine your explain plan?
Jared
On Thursday 31 May 2001 09:00