Using Plan Guides and Plan Freezing

Today one of my customers came to me with a question. The question was “We have some 3rd party applications which heavily use ad-hoc queries with Index Force. Because of changing query optimizer behavior these queries do tons of logical reads. We would like to optimize these queries by removing index forces however we don’t…

2