Insert As Select (IAS) Performs Worse in 18.1 than in 22.214.171.124 with UNION ALL PUSHED PREDICATE Operations
(Doc ID 2666004.1)
Last updated on MAY 07, 2020
Applies to:Oracle Database - Enterprise Edition - Version 126.96.36.199.0 and later
Information in this document applies to any platform.
- INSERT ... AS SELECT is not completing unless OFE is set to 188.8.131.52.
- In this case, setting "_optimizer_cartesian_enabled" = FALSE yields the best time found so far with OFE=18.1.0.
- The major differences between the fast and slow plans are
- - fast : 6 Merge Join Cartesian operations (MJC)
- - slow : 4 MJCs and 2 Union All Pushed Predicate operations
Upgrade from 184.108.40.206 to 18.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