Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

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.



No, original query plan will only expire if indexes are dropped or new ones are created.




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: