All Forums Database
11 Jul 2006
SI or PI will be choosen by Optimizer?

two table are joining and on columns on which one table has both indexes ie PI and Secondary Index on single col say empno, then optimizer will choose which index to access the row, moreover statistics have been collected on Index.

You must sign in to leave a comment.