Hi listers, FYI, skip_unusable_indexes is now a pfile/spfile parameter in 10g (not only alter session based as in 8i/9i) and defaults to ... TRUE. I would prefer FALSE as a better default value. HTH Regards Gilles -- //www.freelists.org/webpage/oracle-l