Number of block access in nested loops -
09-07-2006
, 06:13 PM
Hi,
I read somewhwere about the number of block access in SQL/ORACLE nested
loops can be calculated by this formular:
-(1-1/n)^m
Where
n=the total number of blocks in the table
m=the number of rows you're pinging
Do you know where I can find the full document aobut this?
Thanks
KU |