RE: Buffer Sort explanation

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  

--
http://www.freelists.org/webpage/oracle-l