Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> How to Disable and Enable Indexes?

How to Disable and Enable Indexes?

From: Dino Hsu <dino1_at_ms1.hinet.net>
Date: Wed, 27 Sep 2000 10:48:20 +0800
Message-ID: <8qrn5l$ga5m9$1@ID-41926.news.cis.dfn.de> 






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
Received on Tue Sep 26 2000 - 21:48:20 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US