EXPLAIN EXTENDED

How to create fast database queries

Counting missing rows: using DISTINCT

Comments enabled. I *really* need your comment

This is the 2nd of 5 articles covering implementation of NOT IN predicate in several RDBMS'es:

Today, I will tell about some useful tricks that help to optimize these subqueries even more.

Let's create some sample tables:

Table creation details

Written by Quassnoi

April 19th, 2009 at 11:00 pm

Posted in MySQL

Leave a Reply