RE: Partitioned Explain Plan - Pstart/Pstop = KEY after execution
From: Xiang Rao <xiang_rao_at_hotmail.com>
Date: Thu, 6 Jun 2013 12:25:20 -0400
Message-ID: <BLU177-W1FE05F8349CEDD53BD89495980_at_phx.gbl>
Chris,
> (Unless you're telling me that every partition will be touched in a partition pruning scenario anyway which I don't *think* would happen but perhaps it might)
Date: Thu, 6 Jun 2013 12:25:20 -0400
Message-ID: <BLU177-W1FE05F8349CEDD53BD89495980_at_phx.gbl>
Chris,
> (Unless you're telling me that every partition will be touched in a partition pruning scenario anyway which I don't *think* would happen but perhaps it might)
I have observed similar issues from some of our databases, for CTAS statements (Microstrategy reports). The tables are either range partitioned by multi columns or list, and parallel operations are used. For one case with list partition, the query uses sub query to specify partition key lists. I have been able to solve this one using PRECOMPUTE_SUBQUERY hint.
Thanks.
Xiang
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Jun 06 2013 - 18:25:20 CEST