We're sorry but this page doesn't work properly without JavaScript enabled. Please enable it to continue.
Feedback

Faster Analytics with MariaDB 10.2

Formal Metadata

Title
Faster Analytics with MariaDB 10.2
Subtitle
Advanced SQL features - CTEs and Window Function
Title of Series
Number of Parts
95
Author
License
CC Attribution 4.0 International:
You are free to use, adapt and copy, distribute and transmit the work or content in adapted or unchanged form for any legal purpose as long as the work is attributed to the author in the manner specified by the author or licensor.
Identifiers
Publisher
Release Date
Language

Content Metadata

Subject Area
Genre
Abstract
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.
Keywords