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.

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