Archive for April 19th, 2009
Counting missing rows: using DISTINCT
This is the 2nd of 5 articles covering implementation of NOT IN predicate in several RDBMS‘es:
NOT INin MySQLNOT INin MySQL (usingDISTINCT)NOT INin SQL ServerNOT INin OracleNOT INin PostgreSQL
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 »
Subscribe in a reader