What does the 'BUFFER SORT' step mean and how does it
get calculated, say in below example? It is out of a
tkprof output of a star transformation query.
105 BITMAP MERGE
351549 BITMAP KEY ITERATION
127009880 BUFFER SORT
1607720 TABLE ACCESS FULL SYS_TEMP_4254956840
351549 BITMAP INDEX RANGE SCAN OBJ#(3441108)
PARTITION: 1 177 (object id 3441108)
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Aug 03 2005 - 16:32:35 CDT
