Constraints make a bad performance, but why?
2 posters
Page 1 of 1
Constraints make a bad performance, but why?
Hi all,
why do constraints make a bad performance for loading data in the Data Warehouse? why have they to be disabled while the ETL-Process runs?.
I would appreciate any answer...
Best Regards
why do constraints make a bad performance for loading data in the Data Warehouse? why have they to be disabled while the ETL-Process runs?.
I would appreciate any answer...
Best Regards
asajapin- Posts : 1
Join date : 2011-04-22
Re: Constraints make a bad performance, but why?
I assume you are referring to foreign and primary key constraints... because it requires the database to perform one or more queries every time a row is added.
If you are inserting a row that contains a foreign key with a constraint, the DB must locate the row in the table that the FK is referencing. However, if you are using surrogate key assignment, your ETL code has already handled the check, making the FK constraint redundant.
If you are inserting a row that contains a foreign key with a constraint, the DB must locate the row in the table that the FK is referencing. However, if you are using surrogate key assignment, your ETL code has already handled the check, making the FK constraint redundant.
Similar topics
» how to make others to accept the use of surrogate key?
» How to make reports against a Datamart
» Customer Dim, Vendor Dim, or combined?
» New at BI and data warehousing and trying to make sense of it all.
» Slowly Changing Dimensions - Design Review (Need More Clarification)
» How to make reports against a Datamart
» Customer Dim, Vendor Dim, or combined?
» New at BI and data warehousing and trying to make sense of it all.
» Slowly Changing Dimensions - Design Review (Need More Clarification)
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum