Dne 25.6.2011 02:15, John R Pierce napsal(a):
> indeed, this can really bite you on partitioned tables. My lead
> Oracle programmer would like to see support for prepared statements that
> are parsed but not preplanned... our standard coding model has all the
> queries prepared up front as part of process initialization, and queries
> executed against these prepared statements.
AFAIK Oracle does a plan recheck, i.e. verifies that the prepared plan
is reasonable.
The most serious issue with inheritance and plans (prepared statement
did not reflect partitions created afterwards) has already been fixed.
Tomas