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 |
ahmeds08
Aged Yak Warrior
737 Posts |
Posted - 2011-05-20 : 00:35:17
|
hi everybody,I have a table called CENTERS which has only two records and CENTER_ID is the primary key for the table,and also CENTER_ID is used in many other tables as a foreign key.Now my doubt is, is it required to create a non-clustered index on CENTER_ID column in all the other refering tables???? |
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2011-05-20 : 01:24:19
|
This will depend on a number of factors , including: OLTP v DSS , query structures, data types. Jack Vamvas--------------------http://www.sqlserver-dba.com |
 |
|
Jahanzaib
Posting Yak Master
115 Posts |
Posted - 2011-05-20 : 01:50:01
|
By Default Primary key create a Clustered index if there is no any other clustered index in a table.Indexing depend on the query not on the constraint,check index requirement with the help of query you have developedRegards,Syed Jahanzaib Bin HassanMCTS,MCITP,OCA,OCP,OCE,SCJP,IBMCDBAMy Blogwww.aureus-salah.com |
 |
|
|
|
|
|
|