Thread: Forcing table scan
12-02-05, 04:44 #1Registered User
- Join Date
- Jul 2002
Unanswered: Forcing table scan
I'm experimenting on forcing a table scan using WITH (INDEX(0)) on a table where (according to set showplan_text on) , a clustered index scan is currently used.
However, the clustered index scan is still used, despite the table hint.
Can't I override a *clustered* index this way?