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...
ok sorry. It's on another column let's call it ColX MS
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.
