💾 Archived View for gemini.bortzmeyer.org › fosdem › event-11289.gmi captured on 2022-04-29 at 01:18:53. Gemini links have been rewritten to link to archived content
⬅️ Previous capture (2021-12-17)
-=-=-=-=-=-=-
Øystein Grøvlen
Type devroom
Starts on day 2 (2021-02-07) at 15:30 (Brussels time, UTC+1) in room Mysql (duration 00:30)
Matrix room #mysql:fosdem.org
Two MySQL queries that will return the same result, may sometimes have totally different queries plans. This happens because the query optimizer does not realize that the queries are equivalent. In this presentation, we will discuss how we can rewrite queries to help the optimizer find a better query plan. We will show several examples of how we can transform subqueries to make them more efficient, and we will also discuss how we can identify queries that can become faster if a subquery is replaced by window functions. Finally, we will discuss how MySQL 8.0 can do some of these transformations automatically.