How to create fast database queries

Archive for April 19th, 2009

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:
Read the rest of this entry »

Written by Quassnoi

April 19th, 2009 at 11:00 pm

Posted in MySQL