Re: Temporary Index Disable

From: Randy Harris <randy.harris_at_nospam.net>
Date: Mon, 24 Feb 2003 05:22:52 GMT
Message-ID: <M_h6a.1113$se1.767546@newssvr28.news.prodigy.com>

"DA Morgan" <damorgan_at_exesolutions.com> wrote in message news:3E596424.C466A8CD_at_exesolutions.com...
> Randy Harris wrote:
>
> > What is the best method to temporarily disable indexes to perform a bulk
> > data load? The 8i documentation shows a Disable, but I can't find any
> > syntax that works. Should I just go ahead and drop the indexes then
> > recreate them?
> >
> > --
> > Randy Harris
>
> Indexes can not be disabled: Only dropped and recreated unless those
indexes
> are associated with a constraint.
>
> How large is the data load?

That's a darned good question. I've been examining the matter and beginning to think that the load is not big enough to warrant dropping and then recreating the indexes. I'm loading several tables every 15 minutes, but the biggest load is only about 20,000 records.

> Daniel Morgan
>
Received on Sun Feb 23 2003 - 23:22:52 CST