Sep 29, 2017 06:01 PM|CsharpAsp.net|LINK
I have a table with following columns
Id: Identity Column
This data I am getting from source and inserting in SQL server table
I then have a search page where the users can search on the above table and the results would be shown in a grid.
The search parameters can be company, mod and range of yearmonth.
Now my questions is designing the index on the above table.
Shall I include all the columns of my search param and make them index ie company, mod, yearmonth or just one of them.
Also note that each of would not have unique values.
Would appreciate inputs