You are a database developer. You design a database solution by using SQL Server 2008.
There’s a query which is used very often. You notice that this query executes quite slow.
This query often uses full-table scans while not indexes. Because of this, other queries that modify the table are to be blocked.
On the underlying tables,the indexing strategy that the query uses can change.
Now you have to design a solution which performs the following asks:
• removes removes full-table scans
• allows the query optimizer to select the appropriate index.
So what should you do?
A. Use the NOEXPAND table hint.
B. Use the INDEX table hint.
C. Use the INDEX(0) table hint.
D. Use the the FORCESEEK table hint.
