non clustered index coverage with INCLUDED columns

0 votes

2 answers

82 views

sql-server performance index-tuning nonclustered-index covering-index query-performance

                          If I have two indexes:

    IDX_1 = (COL1), (COL2) DESC
    IDX_2 = (COL1) INCLUDE (COL3)

will a single defined below cover both queries? does the Descending keyword have any bearing on the usage of INCLUDE statement for covering both queries?

    IDX_3 = (COL1) INCLUDE (COL2), (COL3)

Asked by DamagedGoods (2591 rep)

Dec 9, 2019, 11:38 PM
Last activity: Dec 10, 2019, 03:12 PM

non clustered index coverage with INCLUDED columns

Related Questions