Re: Why so many LIO's for select statement doesn't fetch any rows?

Thats fine Carlos. I was just wondering what you base your inference on?
Since you seem to have given OP an impression that his index statistics are wrong and that his query should not use indexes. In fact if the query on a huge table returns 0 uses .. and uses index to
do the filtering .. then indexes would be probably be good!

Anurag Received on Fri Apr 01 2005 - 14:25:11 CST