Re: drop/recreate index

From: Jaap W. van Dijk <j.w.vandijk.removethis_at_hetnet.nl>
Date: Mon, 08 Jan 2007 22:25:55 GMT
Message-ID: <45a2c3a7.436890@news.hetnet.nl>

On 8 Jan 2007 12:37:59 -0800, "hpuxrac" <johnbhurley_at_sbcglobal.net> wrote:
<snip>
>Rebuild index is the more generally preferred alternative these days.
>

Examples don't come to mind, so could you tell in what circumstances?

<snip>
>However, dropping of indexes is often done for batch cycles etc to
>speed up dataloads of large tables.

I prefer setting the indexes to unusable generically, then doing an

alter session skip_unusable indexes=true

and afterwards rebuilding the indexes generically.

In this way you don't have to have create scripts for the indexes, and you are always sure all the indexes are rebuild, and only the indexes that are present.
<snip>

Regards, Jaap. Received on Mon Jan 08 2007 - 16:25:55 CST