Query With XML Functions Doing For Full Table Scan In 12c Compared To 11g
(Doc ID 2555920.1)
Last updated on JANUARY 08, 2020
Applies to:Oracle Database - Enterprise Edition - Version 184.108.40.206 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. 220.127.116.11 software, nor was it observed on the current database, until it was upgraded from Rel. 18.104.22.168 to Rel. 22.214.171.124.
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