EXPLAIN EXTENDED

How to create fast database queries

Archive for March 6th, 2009

Advanced row sampling

with one comment

Yesterday I wrote an article on how to emulate analytiс function ROW_NUMBER() that is present in SQL Server and Oracle, but absent in MySQL.

Today, we will try to optimize this query.
Read the rest of this entry »

Written by Quassnoi

March 6th, 2009 at 9:00 pm

Posted in MySQL