conference logo

Playlist "FrOSCon 2017"

Faster Analytics with MariaDB 10.2

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.