Wednesday, October 3, 2012

Truncate table makes previously UNUSABLE indexes USABLE


Check the example below :

alter index my_idx unusable; --> This make the index unusable
truncate table my_table;
The index my_idx becomes usable !!!


References :
http://www.oramoss.com/blog/2006/07/14/truncate-command-marks-previously-unusable-indexes-as-usable/




No comments:

Post a Comment