Select from following answers:- Ensure that query plan caching is enabled and avoid dynamic queries.

- Ensure that query plan caching is enabled and use dynamic queries over static queries when possible.
- Disable query plan caching and use dynamic queries over static queries when possible.
- All Above
Compiled queries can make a valuable performance improvement for queries that are used repeatedly in an application. You will still pay the compilation cost the first time the query is used, but subsequent uses of the query will avoid that part of the process. Query plan caching is enabled by default. When using query plan caching, avoid dynamically generated queries because caching will use memory for cache entries that are unlikely to be reused.
Show Correct Answer
Source: MeasureUp.Com | |
Alert Moderator