By tenyjemes on
Apr. 23, 2011
United States
Foreign keys ding your performance during inserts, or any updates to the column containing the key. The query engine has to make sure the key exists in the other table, times each row being updated or inserted.