ColA and ColB are indexed seperately (having a compound index did not seem to change this plan)
ColA is 1 of 30 possible values the value in my...
I suppose I'm stuck with the With(Index()), doesn't give you much faith in the plan optimizer <img src='/community/emoticons/emotion-1.gif' alt=':)'...
ITW makes no new recommendations.
I'm really just trying to determine what logic the plan is using to determine why the clustered index may be...
It's on another column
let's call it ColX
the PK is the clustered index. i.e. only involved in query1
I have a table with 50+ columns and 1M rows
The PK is a clustered Index (integer)
Two other Columns are Indexed (colA,ColB)
Query1 = SELECT * FROM...
Separate names with a comma.