Query Tuning Best Practices
(Doc ID 248971.1)
Last updated on SEPTEMBER 20, 2022
Applies to:Oracle Database - Standard Edition - Version 184.108.40.206 to 220.127.116.11 [Release 7.0 to 11.2]
Oracle Database - Enterprise Edition - Version 18.104.22.168 to 22.214.171.124 [Release 6.0 to 11.2]
Oracle Database - Personal Edition - Version 126.96.36.199 to 188.8.131.52 [Release 7.1.4 to 11.2]
Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Information in this document applies to any platform.
This article outlines a number of basic query tuning premises which may be useful to bear in mind when tuning queries.
It is by no means an exhaustive list and will be expanded over time.
Users and DBAs involved in tuning queries
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!