Faster Analytics with MariaDB 10.2

Advanced SQL features - CTEs and Window Function

Vicențiu Ciorbaru

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.

Related

Download

Embed

Share:

Tags