Hi @JohnM I know this question is answered, but I didn't want to start a new thread, because this one, still, is exactly what I wanted to ask...
I'm looking at the missing indexes stat, and see that several suggested indexes have, in the list of included columns, the column (szTransactionId) which is a primary key for the table and a clustered index.
So... is there still a performance gain coming from such index???
The missing index suggestions are just that way. They must have been designed after what I do because there's no guarantee that someone isn't going to move, add to, or even delete the clustered index. It also means that you don't have to lookup the columns in the clustered index when you're troubleshooting, etc.
For those that think manually adding the names of the CI columns are adding additional copies of the columns, you're incorrect.
6 People are following this question.