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.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 indexing

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
Go to Top of Page

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 developed



Regards,

Syed Jahanzaib Bin Hassan
MCTS,MCITP,OCA,OCP,OCE,SCJP,IBMCDBA

My Blog
www.aureus-salah.com
Go to Top of Page
   

- Advertisement -