Common Table Expressions and Window Functions simple, maintainable, fast queries
Vicentiu-Marian Ciorbaru, Software Engineer, MariaDB Foundation delivers his talk, "Common Table Expressions and Window Functions simple, maintainable, fast queries", on DAY 2 of the Percona Live Open Source Database Conference 2017, 4/26, at Santa Clara, CA.
MariaDB Server 10.2 has brought two new important querying features, Common Table Expressions (CTEs) and Window Functions. Both features provide, greater expressibility to queries, which leads to more opportunities for the optimiser to provide speedups
With a focus on analytics, this talk will go through a number of examples on how to transform long complicated queries into simple, maintainable ones. With smart use of window functions, we will see how we can gain an order of magnitude speedup in some scenarios but also how to handle tricky use cases, which would otherwise result in long, complicated and brittle SQL queries.
https://www.percona.com/live/17/sessi...