I have a huge amount of data table EMP with 15 columns, and it has only one primary key with its clustered index, no other indexes are there on table columns.
Now I want to create a non clustered index on this table. How you come to know what are the columns should be there in new index. I dont want to search for how many procedures are using EMP and what columns are they using.
Tell me the way to create Index.