Subject Foreign Keys vs Performance
Author fakuva

I have a database with 34 tables. I have applied foreign keys for all
the relations between the tables (a total number of 48 FK). Now I'm
starting to wonder about the performance for this database. (I use
IBExpert which creates corresponding index/constraint to all the FK,
so the number of indexes is almost 90.)

Occasionally I insert/update 30.000 records in a batch operation. This
operation mainly uses the table with the most FK's (7 FK). Will this
operation be much slower with all the foreign keys?

What is recommended when using foreign keys (apply all fk's or apply
fk where it's most needed?)?

Thanks in advance for any advice.

Bjørn Larsen