When you reactivate them their statistics will be recomputed. Be sure
to recompile your stored procedures to take advantage of the new
information, if the stats have changed.

-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of amoradell
Sent: Monday, April 03, 2006 3:43 PM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Performance with indices

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





++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://firebird.sourceforge.net and click the Resources item on
the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Yahoo! Groups Links