RE: Buffer Sort explanation

From: "Christian Antognini" <Christian.Antognini@xxxxxxxxxxxx>
To: <sharmakdeep_oracle@xxxxxxxxx>
Date: Mon, 8 Aug 2005 11:09:30 +0200

Hi

 

>  Rows       Operation
>  =========  =======================================
>a)       105 BITMAP MERGE
>b)    351549    BITMAP KEY ITERATION
>c) 127009880     BUFFER SORT
>d)   1607720      TABLE ACCESS FULL SYS_TEMP_4254956840
>e)    351549   BITMAP INDEX RANGE SCAN OBJ#(3441108)

 

I'm not able to explain you what the BUFFER SORT exactly does in this case (it 
should only get the data from the temporary table and prepare them for the 
"join" with the index on the fact table... Anyway, each time I have a problem 
with a star transformation with temporary tables I try to disable the temporary 
tables (they were/are buggy!). Therefore try 
star_transformation_enabled=temp_disable.

 

 

Regards,

Chris

Follow-Ups:

RE: Buffer Sort explanation
From: Deepak Sharma

RE: Buffer Sort explanation

Other related posts: