Oracle 9.2x on Windows.

Any tips on getting rid of the buffer sort in this xplan?

----------------------------------------------------------------------------
---------------
| Id | Operation | Name | Rows |
Bytes | Cost |
----------------------------------------------------------------------------
---------------
| 0 | SELECT STATEMENT | | 10 |
460 | 5 |
|* 1 | CONNECT BY WITH FILTERING | | |
| |
| 2 | NESTED LOOPS | | |
| |
|* 3 | INDEX SKIP SCAN | PK_SOL_OBJECT_MEMBER | 1 |
26 | 12 |
| 4 | TABLE ACCESS BY USER ROWID | SOL_OBJECT_MEMBER | |
| |
| 5 | NESTED LOOPS | | |
| |
| 6 | BUFFER SORT | | 10 |
460 | |
| 7 | CONNECT BY PUMP | | |
| |
| 8 | TABLE ACCESS BY INDEX ROWID| SOL_OBJECT_MEMBER | 10 |
460 | 5 |
|* 9 | INDEX RANGE SCAN | PK_SOL_OBJECT_MEMBER | 10 |
| 3 |
----------------------------------------------------------------------------
---------------

Predicate Information (identified by operation id):
---------------------------------------------------

1 -
filter(RAWTOHEX("SOL_OBJECT_MEMBER"."SOLUTION_ID") ='0F9233A0836B91D892BEAC10
0
0A90000' AND "SOL_OBJECT_MEMBER"."OBJECT_ID"=1 AND
"SOL_OBJECT_MEM
BER"."MEMBER_ID"<>0)
3 - access("SOL_OBJECT_MEMBER"."OBJECT_ID"=1)

filter(RAWTOHEX("SOL_OBJECT_MEMBER"."SOLUTION_ID") ='0F9233A0836B91D892BEAC10
0
0A90000' AND "SOL_OBJECT_MEMBER"."OBJECT_ID"=1 AND
"SOL_OBJECT_MEM
BER"."MEMBER_ID"<>0)
9 - access("SOL_OBJECT_MEMBER"."SOLUTION_ID"=NULL AND
"SOL_OBJECT_MEMBER"."OB
JECT_ID"=NULL)

You may want to look at this.
http://www.jlcomp.demon.co.uk/faq/tuning_explain.html
regards
Srivenu

Thanks, Srivenu!

"srivenu" <srivenu@hotmail.com> wrote in message
news:1a68177.0404072159.399d9eca@posting.google.co m...
> You may want to look at this.
> http://www.jlcomp.demon.co.uk/faq/tuning_explain.html
> regards
> Srivenu