Before you use forceplan:
Check the showplan output to determine whether index keys are used as expected.
Use dbcc traceon(302) or set option show normal to look for other optimization problems.
Run update statistics on the index.
Use update statistics to add statistics for search arguments on unindexed search clauses in the query, especially for search arguments that match minor keys in compound indexes.
Use set option show_missing_stats on to look for column(s) that may need statistics.
If the query joins more than four tables, use set table count to see if it results in an improved join order.
See “Specifying the number of tables considered by the query processor”.
