I ran a report and execution plan suggested a 'missing index' with 4 index key columns and 4 included columns. I created the index and ran the report again it gave me 'missing index' suggestion again with now 2 key columns and 2 included columns which were part of the missing index of the first time.
I added those again and it ran even BETTER with no 'missing index' suggestion.
My question is since 2nd index columns are already in the 1st index how can I make only one index instead of 2? another word how to combine? Thanks
Example: First missing index suggestion:
Create NonClustered index 11111 (col1, col2, col3, col4) on mytable inculde (col5, col6, col7, col8)
Second index suggestion
Create NonClustered index 22222 (col1, col4) on mytable inculde (col7, col8)
- This topic was modified 1 week, 5 days ago by Tac11.