How to create fast database queries

Archive for March 6th, 2009

Advanced row sampling

Comments enabled. I *really* need your 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