Re: PROBLEM: Cannot rebuild index!!

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Fri, 30 Dec 2005 15:52:24 -0500
Message-ID: <YLidnQKs6_2UAyjeRVn-gw@comcast.com>

"BD" <bobby_dread_at_hotmail.com> wrote in message news:1135973106.734050.78140_at_g44g2000cwa.googlegroups.com...
>I found out why the dupes came into play:
>
> We drop indexes, then do the inserts from the remote db, and re-enable
> the indexes. It's entirely possible that the source db has made some
> changes to how they index their tables.
>
> We'll have to contact the dbas of the source db and see if they've made
> some RI changes somewhere...
>
> Blissfully, this particular dataset is not yet in use by anyone, so if
> it's broken we won't suffer. ;)
>

why is it necessary to drop and recreate the indexes when adding rows to the table?

++ mcs Received on Fri Dec 30 2005 - 14:52:24 CST