Hint for Table Scan 1

[nnkumar]

For tables with no Clustered index, hint INDEX(0) will force a table scan. But, I query a table with Clustered index. Is there any hint to force the optimizer to do a Table scan? I am using SQL Server 2000.

Thanks in Advance.

 

[TomSark]

Once you have a clustered index on a table, it will always be used due to the fact that the data exists in the leaf node of the index. Sorry, but you cannot do this without dropping the index.
Tom Davis
tdavis@sark.com

http://www.sarkdallas.com