Subject Performance with indices
Author amoradell
Hi,

I have to load several thousands records in a database through text
files of about 100000 records each.

The records are put into several tables (about 20 with one exceding 10
million records).

For performance reasons, I must deactivate almost every index and also
triggers.

I have only primary keys activated to avoid duplicates.

I want to know if these indices on primary keys have their statistics
up to date or do I have to recompute them between each file to
maintain good performance ?

Thanks

Alexandre