Skip to Main Content

Unusable Indexes

JaffySep 3 2008 — edited Sep 3 2008
Hi,

I have been experiencing some indexes being unusable due to which queries and jobs taking much longer to finish. As it is very big indices its a big overhead to rebuild those indices on time, so please can anyone help here what may be cause of indices being unusable how to resolve it and factors should we look into to avoid the problem in near future.

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 on Solaris.

Thanks and Regards

Jafar

http://www.oracledbarea.blogspot.com
Comments
Post Details
Added on Sep 3 2008
10 comments
848 views