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