Re: using "alter index xxx unusable"

From: Michael Peel <peelm_at_NOSPAMaccuread.com>
Date: Tue, 13 Dec 2005 14:54:54 GMT
Message-ID: <Xns972B97EE8840FpeelmNOSPAMaccureadc@194.6.79.66>

Hi,

Thanks for the reply…

I don’t like using the drop/rebuild option, because if the rebuild fails, you don’t necessarily know about it (unless you check your logs, which of course we all do). If the index rebuild fails, any sql trying to use the index will fail with a meaningful message.

"hpuxrac" <johnbhurley_at_sbcglobal.net> wrote in news:1134485197.291281.141100_at_o13g2000cwo.googlegroups.com:

> One alternative is to drop the indexes entirely and create them after
> your insert procedure.
>
Received on Tue Dec 13 2005 - 08:54:54 CST