Lecture: Faster Analytics with MariaDB 10.2
Advanced SQL features - CTEs and Window Function
MariaDB 10.2 has brought two new important querying features, Common Table Expressions (CTEs) and Window Functions. Both features provide greater expressibility to queries, thus opening up opportunities for the optimiser to provide speedups not previously achievable.
With a focus on analytical queries, we will see how to improve query performance sometimes by an order of magnitude compared to regular SQL.
The agenda for the talk is:
* What are CTEs
* What are window functions
* Solving problems with regular SQL and window functions
* Smoothing data
* Top-N Queries
* Difference between consecutive rows