Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
jabu
Starting Member
2 Posts |
Posted - 2012-10-09 : 07:50:35
|
Why do constraints use indexes? |
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2012-10-09 : 09:26:14
|
Unique and primary key constraints use indexes to maintain uniqueness, foreign keys, check and default constraints do not. Index structures make it easier to navigate key values and are more efficient if you have to search for a possibly duplicate value.SQL Server uses B+ Trees as their index structure, you can read about them here:http://en.wikipedia.org/wiki/B%2B_treehttp://msdn.microsoft.com/en-us/library/ms177484.aspxhttp://msdn.microsoft.com/en-us/library/ms177443.aspx |
|
|
|
|
|