Re: RBO changes plan from 8i to 9i

Hi again

I just noticed some minor changes in DELETE plans as well, instead of

DELETE STATEMENT null

          DELETE    null
                TABLE ACCESS    BY INDEX ROWID
                INDEX    RANGE SCAN

in 8.1.7.4 I see now

DELETE STATEMENT null

          DELETE    null
                INDEX    RANGE SCAN

Again it's very minor change, table access is no longer needed.

What is this new feature called...?

Thanks

Alex

--
http://www.freelists.org/webpage/oracle-l