Make use of UNUSABLE_INDEX by uisnh HInt [message #654136] |
Wed, 27 July 2016 05:38 |
|
saipradyumn
Messages: 419 Registered: October 2011 Location: Hyderabad
|
Senior Member |
|
|
Hi All ,
Is there any way to make use the index which is UNUSABLE (Other than REBUILD Option & SKIP_UNUSABLE_INDEXES Parameter)?
Following the is code snippet :
CREATE TABLE INDEX_NOTUSED (ID NUMBER PRIMARY KEY ) ;
INSERT INTO INDEX_NOTUSED SELECT ROWNUM+10 FROM DUAL CONNECT BY LEVEL < 10 ;
SELECT * FROM USER_IND_COLUMNS WHERE TABLE_NAME ='INDEX_NOTUSED';
ALTER INDEX SYS_C00123779 unusable ;
Thanks
Sai Pradyumn
|
|
|
|
|
|
|