You may be aware that plan guides will help the optimizer to perform better and a general recommendation is to use the relevant USE PLAN query hint when the other standard query tuning options are failed. It is also necessary to test through the results...
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
Tue, Oct 30 2007
Filed under: Filed under: sql server, performance, indexes, services, hotfix, planning, service pack, best practice, testing, plan guide