Re: How to Disable and Enable Indexes?

In article <8qrn5l$ga5m9$1_at_ID-41926.news.cis.dfn.de>,   "Dino Hsu" <dino1_at_ms1.hinet.net> wrote:
> Dear All,
>
> We have a Data Mart system with Oracle, new data are daily loaded
 into the
> database with a script program. Some indexes can make SQL Loader at
 least 10
> times slower, is there a way to disable the indexes temperarily so
 that SQL
> Loader will not be influenced? If there is no way, dropping indexes
 and
> re-creating them back will be necessary. Thanks in advance.
>
> Regards,
> Dino
>
>

Generally speaking you should not load in production tables *directly* as you can create havoc very easily. Using the direct mode of sql*loader will bypass the sql layer and the indexes, and you will have to *rebuild* (so alter index rebuild, not drop and create) them, but after a bulk load this is necessary anyway.

Regards,

--
Sybrand Bakker, Oracle DBA

All standard disclaimers apply
------------------------------------------------------------------------


Sent via Deja.com http://www.deja.com/
Before you buy.