Solved

Costly buffer sort causes a slow query

Posted on 2008-09-30
2
2,225 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
2 Comments
 
LVL 142

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Oracle Database Upgrade 13 62
Oracle regular expression 6 45
Oracle - Stored Procedure Privilge access 3 39
Difference in number of minutes between 2 timestamps 16 39
Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
Via a live example, show how to take different types of Oracle backups using RMAN.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

911 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

Need Help in Real-Time?

Connect with top rated Experts

28 Experts available now in Live!

Get 1:1 Help Now