Hiding Indexes

Posted by admin on Nov 25, 2013 in Database, Oracle |

I just found out that its possible to hide indexes rather than making them unusable.

alter session set ddl_lock_timeout = 10;
alter index INDEX_START_DATE_TIME invisible;

This is beneficial because the index does not have to be rebuilt it it is made visible again.

Leave a Reply

XHTML: You can use these tags:' <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

Copyright © 2008-2017 Brinsmead Data Services All rights reserved.