Sachin Bankar (12/2/2014)
Can I consolidate above index to a single index?
Yes
Is sequence important?
Not of includes
Note : If these indexes have been automatically created by DBA based automatic analyser suggestions and plans. Should this technique be followed should we create indexes for all aumatic query plans?
Never automatically create indexes based off query plans. Always test and see if the index is even useful, check for similar indexes that can be altered. Use some common sense as to whether the index is a good idea or not
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability