News for hackers. Stuff that matters.
Re:Ex-Facebookers launch MemSQL (YC W11) to make your databa... by chris_wot on Monday June 18, 2012 @10:31AM (#4126562)
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.

Re:Ex-Facebookers launch MemSQL (YC W11) to make your databa... by tintor on Monday June 18, 2012 @11:06AM (#4126709)
No, original query plan will only expire if indexes are dropped or new ones are created.