Subject | Performance with indices |
---|---|
Author | amoradell |
Post date | 2006-04-03T19:42:42Z |
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
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