My Oracle Support Banner

Query Tuning Best Practices (Doc ID 248971.1)

Last updated on JUNE 15, 2021

Applies to:

Oracle Database - Standard Edition - Version 7.0.16.0 to 11.2.0.3 [Release 7.0 to 11.2]
Oracle Database - Enterprise Edition - Version 6.0.0.0 to 11.2.0.3 [Release 6.0 to 11.2]
Oracle Database - Personal Edition - Version 7.1.4.0 to 11.2.0.3 [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.

Purpose

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.

Scope

 Users and DBAs involved in tuning queries

Details

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.