Where to create Index on a column Primary Key or Foreign Key

Last Reply on Jan 30, 2013 05:10 AM By Narendra

Posted on Jan 21, 2013 04:26 AM

hello sir on which key mns on Primary key or on Reference key we apply Indexing ??? Thnx in advance

Posted on Jan 30, 2013 05:10 AM

 AS MR.MUDASAR SAID INDEX WILL CREATE ON PRIMARY KEYS COLOUMN IF YOU ARE GOING ON  COUPLE OF TABLES  GO WITH THE JOINS WHERE PRIMARY KEY IS AN INDEX FOR THE TABLE'S

OR WHERE CLAUSE ETC...

 

FOR REF :http://bytes.com/topic/sql-server/answers/142644-create-index-large-table