Query Regression After Upgraded Database To 12c Due to 'VIEW PUSHED PREDICATES'
(Doc ID 2445377.1)
Last updated on FEBRUARY 20, 2019
Applies to:Oracle Database - Enterprise Edition - Version 188.8.131.52 to 184.108.40.206 [Release 12.1 to 12.2]
Information in this document applies to any platform.
- Query regression after upgraded database to 12.1 and 12.2 from 11204
Due to 'VIEW PUSHED PREDICATES' leads to bad cost and execution:VIEW PUSHED PREDICATE VW_11 (cr=31214568 pr=31111082 pw=0 time=334206484 us starts=12937 cost=396 size=9 card=1) <<<<<<<<
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