Costly buffer sort causes a slow query

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?

LVL 10
ivanovnAsked:
Who is Participating?
 
ivanovnConnect With a Mentor Author Commented:
Nevermind... converting a few WHERE clauses to LEFT JOIN bypassed that the costly step. Thanks for taking the time to assist.
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
can you show the query, and the table structure?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.