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...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
by
on
Tue, Oct 30 2007
Filed under:
Filed under: sql server, performance, indexes, services, hotfix, planning, service pack, best practice, testing, plan guide