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?