I have "INDEX" table with the below columns and having 100 millions of records.
indexid varchar(50) -- this is alphanumeric data that is the reason i have used varchar
with NON CLUSTERED INDEX on insertdate column
when i run the below query it is taking to much time to return the result.
select * from INDEX where indexid='xxxxxxxxxxxx' and indextype='xxxxxxxxx'
here my question is Can i create NON CLUSTERED INDEX on both indexid and indextype columns to improve the performance of the query.
Note: both indexid and indextype columns may have duplicate data.
should i create individual NON CLUSTERED INDEX on each column or should i create single composite NON CLUSTERED INDEX on both columns
please help me on this. Thanks in advance