Two plans given in your example looks very much the same to me, aside from the "table prefetching" bit of 9i Thanks, Boris Dali. __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- //www.freelists.org/webpage/oracle-l