Solved

Costly buffer sort causes a slow query

Posted on 2008-09-30
2
2,264 Views
Last Modified: 2013-12-18
I have a query that runs extremely slow. When I ran the explain plan I noticed that there is a buffer sort whose cost accounts for almost all of the cost of the entire query.

The buffer sort is done on a full access of indexed and analyzed table with only 32 rows. Why is this happening and how could I reduce the cost of that step?

0
Comment
Question by:ivanovn
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 22609098
can you show the query, and the table structure?
0
 
LVL 10

Accepted Solution

by:
ivanovn earned 0 total points
ID: 22609547
Nevermind... converting a few WHERE clauses to LEFT JOIN bypassed that the costly step. Thanks for taking the time to assist.
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question