Set operations UNION, INTERSECT, and EXCEPT in MariaDB
How to use and combine them.
- Track: MariaDB devroom
- Room: D.mariadb
- Day: Saturday
- Start: 13:55
- End: 14:20
- Video with Q&A: D.mariadb
- Video only: D.mariadb
- Chat: Join the conversation!
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.
Speakers
Oleksandr Byelkin |