Forcescan Table Hint in SQL Server

The force scan table hints in SQL Server force the query to perform a table scan even if an index is available. This means SQL Server reads all rows sequentially ignoring any existing index.

Syntex

Select * from table with (Forcescan) where column1=’value’

It scans full table and ignores the index. It avoids force scan in large table due to that query will become slow. It increases the high CUP and I/O uses due to scanning the entire table.