Drop Index or set Unusable

From: nimonic <nimonic_at_excite.com>
Date: 23 Jan 2005 15:28:18 -0800
Message-ID: <2cabdd32.0501231528.a2bb339@posting.google.com>

I have a generic stored procedure that sets indexes unusable to speed up inserts in a data warehousing environment. I have been told by the DBA that setting indexes unusable is not standard data warehousing practice and the indexes should be dropped and recreated instead. I was told at an Oracle course that setting the index unusable was the better option.

The tables are partitioned by range with local partitioned indexes.

What is the best method and why?

Version 8.1.7.4.0 Received on Sun Jan 23 2005 - 17:28:18 CST