Query Tuning Best Practices
(Doc ID 248971.1)
Last updated on JUNE 15, 2021
Applies to:Oracle Database - Standard Edition - Version 220.127.116.11 to 18.104.22.168 [Release 7.0 to 11.2]
Oracle Database - Enterprise Edition - Version 22.214.171.124 to 126.96.36.199 [Release 6.0 to 11.2]
Oracle Database - Personal Edition - Version 188.8.131.52 to 184.108.40.206 [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!