Required Inputs on the Execution Plan

Sharath 2016-01-29 18:29:28

Team,

We are in a process of evaluating the attached plan and would like to get some insights on the below:

  • Based on the execution results we are planning to create clustered index. This is a DW environment and we already have a Columnstore Index. Does this have a significant boost on the performance of having both clustered index and columnstore index?
  • We did implement a Non clustered Index and it didnt serve the purpose to great extent unless columns were included which is huge at this point.