Query Elapsed Time on Partitioned Table Slower in Parallel Execution than Serial, though Cost in Parallel is Lower
(Doc ID 2643506.1)
Last updated on APRIL 30, 2020
Applies to:Oracle Database - Enterprise Edition - Version 126.96.36.199.0 and later
Information in this document applies to any platform.
- A query against a partitioned table completes more quickly serially, than in parallel, even though the estimated cost in parallel execution is less than that of serial
- Setting OPTIMIZER_FEATURES_ENABLE to an older release level does not help nor does enabling Adaptive Parallel Distribution
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document