My Oracle Support Banner

Tuning Queries: 'Quick and Dirty' Solutions (Doc ID 207434.1)

Last updated on SEPTEMBER 20, 2022

Applies to:

Oracle Database - Enterprise Edition - Version and later
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
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.


Sometimes, when a query is performing badly, a solution is needed right away.
Other considerations are insignificant compared to the performance of this query.

In this situation a trial and error approach 'might' get the query to work in the required fashion. This article provides several trial and error suggestions that can be tried will little analysis.

The scope of this article is limited to factors affecting the costing algorithms in the Cost Based Optimizer (CBO). Only the most common examples are covered.
The article should be relevant to people seeking quick 'fixes' to query tuning problems.

Please also refer to the following articles which provide action plans for issues as well as some suggestions:

<Document 742112.1> Support Action Plan for Query Performance Degradation
<Document 745216.1> Support Action Plan for Query Performance Degradation After Upgrade


NOTE: There is a presentation entitled "Tips for Preventing Suboptimal Execution plans" available in:

<Document:1380043.1> Selected Performance Related Seminars from Oracle Openworld

Which also addresses and provides specific tips on this subject.

Troubleshooting Steps

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
Troubleshooting Steps
 Potential Solutions

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