Online / 6 & 7 February 2021


Set operations UNION, INTERSECT, and EXCEPT in MariaDB

How to use and combine them.

The presentation will show how and why use UNION/INTERSECT/EXCEPT. How combine them to get expected result.

We will also dive into implementation details (with the help of the EXPLAIN command) to understand how MariaDB executes these set operators. This will help in understanding and troubleshooting performance problems.


Photo of Oleksandr Byelkin Oleksandr Byelkin