Query With XML Functions Doing For Full Table Scan In 12c Compared To 11g
(Doc ID 2555920.1)
Last updated on JULY 11, 2019
Applies to:Oracle Database - Enterprise Edition - Version 220.127.116.11 and later
Information in this document applies to any platform.
- INSERT INTO ... SELECT statement, in which the SELECT portion is an ANSI join, which references XML functions, is accessing table, AXIOM_TASKS does a full table scan instead index
- This behavior is not seen on a database running with Rel. 18.104.22.168 software, nor was it observed on the current database, until it was upgraded from Rel. 22.214.171.124 to Rel. 126.96.36.199.
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