XMLCast XQuery Not Using Index When Mixed Is True
(Doc ID 1341617.1)
Last updated on SEPTEMBER 01, 2022
Applies to:
Oracle Database Cloud Schema Service - Version N/A and laterOracle Database Cloud Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Oracle Database - Enterprise Edition - Version 11.2.0.1 to 11.2.0.4 [Release 11.2]
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Information in this document applies to any platform.
Symptoms
SELECT and DELETE do not use Index When the element has mixed="true":
Scenario 1: Using FirstName in the query:
FirstName has an extra level of complexity due to the attribute "type" but the cause of the problem is not the attribute but the mixed="true"
How can we make the SELECT and DELETE to use the INDEX instead of FTS with ELEMENT FirstName
Cause
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
| Symptoms |
| Cause |
| Solution |
| References |