UNUSABLE INDEXES IN ORACLE 10G
1 view
Skip to first unread message
sampath
Dec 15, 2008, 10:28:26 AM12/15/08
to Ask Oracle DBA
In prior versions to 10g when a query executed by a user try to use an
index which is in UNUSABLE state It immediately returns an error.
But from the release of 10g If a statement attempts to use an unusable
index, oracle will generate a execution plan which does not require
the index. Thus, statements will always
succeed—but perhaps at the cost of greatly reduced performance.
If you want oracle to behave as in prior version to 10g you can set
SKIP_UNUSABLE_INDEXES to false. the default value of this parameter is
true.
index which is in UNUSABLE state It immediately returns an error.
But from the release of 10g If a statement attempts to use an unusable
index, oracle will generate a execution plan which does not require
the index. Thus, statements will always
succeed—but perhaps at the cost of greatly reduced performance.
If you want oracle to behave as in prior version to 10g you can set
SKIP_UNUSABLE_INDEXES to false. the default value of this parameter is
true.
Reply all
Reply to author
Forward
0 new messages