Hi I dont have acesses to the box right now but would be having sometime later. I didnt quite understand the statement "Check if the join criteria between SC and SH are correlated" How do i check that ? regards Hrishy -- //www.freelists.org/webpage/oracle-l