Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> 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.Received on Wed Sep 27 2000 - 01:31:53 CDT