Partitioned Explain Plan - Pstart/Pstop = KEY after execution
From: <Christopher.Taylor2_at_parallon.net>
Date: Thu, 6 Jun 2013 10:16:48 -0500
Message-ID: <F05D8DF1FB25F44085DB74CB916678E887A05B427D_at_NADCWPMSGCMS10.hca.corpad.net>
Env: 10.2.0.4 RAC Linux 64-bit
I've got an explain plan with Pstart/Pstop with "KEY" instead of partition numbers. I've been reading http://www.oracle.com/technetwork/database/bi-datawarehousing/twp-explain-the-explain-plan-052011-393674.pdf (The Oracle Optimizer Explain the Explain Plan) and it explains that KEY is used when Oracle believes the execution will dynamically partition prune.
Date: Thu, 6 Jun 2013 10:16:48 -0500
Message-ID: <F05D8DF1FB25F44085DB74CB916678E887A05B427D_at_NADCWPMSGCMS10.hca.corpad.net>
Env: 10.2.0.4 RAC Linux 64-bit
I've got an explain plan with Pstart/Pstop with "KEY" instead of partition numbers. I've been reading http://www.oracle.com/technetwork/database/bi-datawarehousing/twp-explain-the-explain-plan-052011-393674.pdf (The Oracle Optimizer Explain the Explain Plan) and it explains that KEY is used when Oracle believes the execution will dynamically partition prune.
So I executed my statement and traced it (of course) and still the explain plan shows KEY KEY and running it through orasrp shows that many partitions were scanned (perhaps not all of them however - I haven't checked).
So, is it safe to say that *after* execution if the plan has KEY KEY then partition pruning did not occur?
Thanks!!
Chris Taylor
Oracle DBA
Parallon IT&S
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Jun 06 2013 - 17:16:48 CEST