APPLICATION SQL PERFORMANCE DEGRADE DUE TO TABLE ACCESS FULL FOR "OR" QUERIES
(Doc ID 2867860.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 12.1.0.1 to 19.15.0.0.0 [Release 12.1 to 19]Information in this document applies to any platform.
Symptoms
SQL running slow due to full Table scan
Application Queries with "OR" Expansion favoring Full Table Access.
Changes
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 |
| Changes |
| Cause |
| Solution |
| References |