In MySQL 8.0.17, we made an observation in the well-known TPC-H benchmark for one particular query. The query was executing 20% faster than in MySQL 8.0.16.
https://mysqlserverteam.com/antijoin-in-mysql-8/
wtf?
origin - https://www.pipiscrew.com/?p=16365 antijoin-in-mysql-8