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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Index troubles with SQLLoader

Re: Index troubles with SQLLoader

From: Chris Weiss <weisschr_at_pilot.msu.edu>
Date: Wed, 26 May 1999 09:26:54 -0400
Message-ID: <7igski$647$1@msunews.cl.msu.edu>


It is best to drop all of your constraints, perform your load and then rebuild and reapply your constraints.

B*tree indexes are optimized when they are rebuilt.

Chris

x_at_x.com wrote in message <7iffhf$glr$1_at_mars.worldonline.fr>...
>Ok, I done that for all my indexes that are not on the Primary Key
>(PK_THIRD).
>Nothing is changing.
>I guess the trouble is on my Pk_third index but I need drop my PK before
>(?).
>I can't do because I had old data in the THIRD table that have their PK
used
>into others tables : I use SQLLoader in APPEND mode.
>
>Do I always recreate indexes when I load datas with SQLLoader ?
>
>Thanks for help.
>
>Chris Weiss a écrit dans le message <7if2j6$61m$1_at_msunews.cl.msu.edu>...
>>Drop and recreate your index before you perform the delete.
>>
>>Chris
>>
>>
>
>
>
Received on Wed May 26 1999 - 08:26:54 CDT

Original text of this message

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