News for hackers. Stuff that matters.

A comment on Ex-Facebookers launch MemSQL (YC W11) to make your database fly. Parent comment

Re:Ex-Facebookers launch MemSQL (YC W11) to make your databa... by nikita on Monday June 18, 2012 @10:11AM (#4126479)
Right now you can handle this with query hints. The plans are stable, but they are attached to the query text. When you throw a hint in there memsql generates a new plan since the query text changes.
[ Parent | on HN ]
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.

[ Parent | on HN ]
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.
[ Parent | on HN ]