Performance Tuning SQL Server Constraints

The Query Optimizer can use constraints to help it select the best performing query. In order to get the best performance, it is important that you use them appropriately throughout your database application, such as using them for primary keys, unique keys, primary keys, and so on. [6.5, 7.0, 2000, 2005] Updated 11-6-2006

*****

If you have a choice between using a trigger or a CHECK constraint to enforce rules or defaults within your SQL Server databases, you will generally want to choose a CHECK constraint, as they are faster than using triggers when performing the same task. [6.5, 7.0, 2000, 2005] Updated 11-6-2006




Related Articles :

  • No Related Articles Found

No comments yet... Be the first to leave a reply!

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |