Performance on indexes with and without fillfactors

[Praveena]

Hi all,
Data load on a database without indexes(only nonclustered indexes on primary keys) took appx. 45 minutes.
Data load on the same database after creating many indexes (with default fillfactor of 0%)to improve query execution time took appx. 45 minutes.
Data load on the same database after creating many indexes (with fillfactor of 70%)to improve load time took appx. 90 minutes.

Can someone see the reason for this or justify this behaviour please?

Thanks in advance,
Praveena

[Sushruth]

Indexes will not do any good if you are planning to decrease your load time.
This is because when youu have indexes on your tables,
it will be a logged operation and can even fill up your tran log if ithe file is big.
And also, more the number of indexes , more is the time taken for data uploads. So the bhaviour you see is perfectly normal.
TO improve your load time, drop all the indexes whether clustered on nonclustered and perform the upload and make sure that
select into bulk copy option is set on for your database.
After the upload recreate your indexes.2



------------
Praveena at 3/16/01 8:47:33 PM

Hi all,
Data load on a database without indexes(only nonclustered indexes on primary keys) took appx. 45 minutes.
Data load on the same database after creating many indexes (with default fillfactor of 0%)to improve query execution time took appx. 45 minutes.
Data load on the same database after creating many indexes (with fillfactor of 70%)to improve load time took appx. 90 minutes.

Can someone see the reason for this or justify this behaviour please?

Thanks in advance,
Praveena