Re: Corrupted Index?

Is the optimizer cost-based or rule-based. You can change your optimizer mode for your session and run the query again. I have seen problems with the cost-based not returning all the data it should.

-- 
***********************************************************************


*  Gayle Masters                              glmaster_at_jol.mobil.com  *

*  Mobil Oil Corporation                                              *

*  P.O. Box 874                               Phone: +1.815.423.7780  *


*  Joliet, Illinois  60434                      Fax: +1.815.423.7726  *


***********************************************************************