3 ms·
To clarify - if you add the query hint, run the query, then remove the query hint then has the original query's plan expired? Edit: I know I'm asking a lot abo
by chris_wot 14y ago
To clarify - if you add the query hint, run the query, then remove the query hint then has the original query's plan expired?
Edit: I know I'm asking a lot about the plan cache, but as it's a core selling point, then I'd like to know how data distribution changes will affect performance. Stale queries will potentially adversley affect performance under certain circumstances.
- tintor 14y agoNo, original query plan will only expire if indexes are dropped or new ones are created.