Best way to create non clustered index
I am having one table contains 30+ Million records. The table structure is as follows,
Most of the operations on this table are
– Select indx_val based on col1, start_dt
– Select indx_val based on col1, end_dt
– Update indx_val based on col1, start_dt
– Update indx_val based on col1, end_dt
I am trying to create two non clustered indexes
one on col1, start_dt and indx_val as include field and another one as col1, end_dt and indx_val as include field.
Please suggest as this approach is good or any other approach which makes better performance.
Thanks in advance.