Re: Indexing Problem

On 6 Apr 2004 09:59:39 -0700, susanths_at_hotmail.com (Susanth Sivaram) wrote:

>Hi,
>I have a table which has 9 indexes. With 9 indexes, inserting takes a
>lot of time. It takes around 57 minutes for inserting. For the same
>number of records with out indexes, it takes 44 seconds. This large
>time difference in inserting, reduces the performance of the system.
>Pls help in getting around with this problem.

Have you tried dropping the indexes before inserting, doing the batch of inserts and then recreating the index?

Lemming

-- 
Curiosity *may* have killed Schrodinger's cat.