• ChrisM@Work (4/16/2014)


    EasyBoy (4/15/2014)


    I did try almost all combination of altering columns for index, but somehow logical reads are same (67000).

    Did you look at the execution plans to see if the hash aggregate was replaced with a stream aggregate? If you're not sure, then create the index which Gail suggests and post the execution plan here.

    Please find the updated execution plan.