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 r
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 ;
select * from plan_table;
There should be two columns that indicate the partitio
Check optimizer_mode in v$parameter for your session. I don't think it will eliminate
partitions if it is RULE.
Here is an explain plan from a simple select on a partitioned table. An index exists:
SELECT STATEMENT Optimizer=CHOOSE (Cost=1.69535189333285 Card=32 Bytes=3488)
PARTITION RANGE
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 when
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 column
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 elimi
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,
Many thanks for the replies on this.
I was indeed using autotrace instead of doing an explain plan with utlxpls.
I have also found the detail I was looking for in the documentation (can't
beleive I didn't seee it before, it must have been a long day!!).
Cheers,
Dave Leach
-Original Message