My Oracle Support Banner

Query Tuning Best Practices (Doc ID 248971.1)

Last updated on SEPTEMBER 20, 2022

Applies to:

Oracle Database - Standard Edition - Version to [Release 7.0 to 11.2]
Oracle Database - Enterprise Edition - Version to [Release 6.0 to 11.2]
Oracle Database - Personal Edition - Version to [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!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.