Re: Index troubles with SQLLoader

From: Chris Weiss <>
Date: Wed, 26 May 1999 09:26:54 -0400
Message-ID: <7igski$647$>

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 wrote in message <7iffhf$glr$>...
>Ok, I done that for all my indexes that are not on the Primary Key
>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
>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$>...
>>Drop and recreate your index before you perform the delete.
Received on Wed May 26 1999 - 15:26:54 CEST

Original text of this message