actually there is no need to aggregate the some value. only need to identify the distinct records. which also can be possible using the group by clause. so i just...

Hi,

Please try to create the non cluster index which you are selecting and using in the where clause.

If there are multiple columns, try to identify the main columns which...