Backup source of 2008-04-22 (No. 1)

• Backup list
• View the diff.
• View the diff current.
• View the diff for visual.
• View the backup.
• Go to 2008-04-22.
  • 1 (2008-04-22 (Tue) 20:23:54)

- 「MySQLのUsing Filesort」クエリーの分割
--  http://d.hatena.ne.jp/kenji-u/20071102/p1

 select * from tbl where a = 1 and b = 1 order by c;

 CREATE TEMPORARY TABLE tmp1 SELECT * FROM tbl  WHERE a = 1;
 CREATE TEMPORARY TABLE tmp2 SELECT * FROM tmp1 WHERE b = 1;
 SELECT * FROM tmp2 ORDER BY c;