Required Inputs on the Execution Plan
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.