mysql:14776
From: HIRATSUKA Sadao <HIRATSUKA Sadao <hiratsuka.sadao@xxxxxxxxxx>>
Date: Thu, 12 Mar 2009 10:20:06 +0900
Subject: [mysql 14776] Re: MySQL による ORDER BY の最適化
間違えました… > このとき、以下のSQLは > SELECT * FROM t1 WHERE key1 = 2 ORDER BY key2 SELECT * FROM t1 WHERE key1 = 1 ORDER BY key2 です。 > (1, 1), // ここから > (1, 2), > (1, 2), > (1, 2), > (1, 3), > (1, 3), // ここまで > (2, 1), > (2, 1), > (2, 2), > (2, 3), > (2, 3), > (2, 3), > (3, 1), > (3, 2), > (3, 3) -- 平塚貞夫 hiratsuka.sadao@xxxxxxxxxx
14773 2009-03-12 09:31 ["linux@xxxxxxxxxx" <] MySQL による ORDER BY の最適化 14774 2009-03-12 09:50 ┣[Mikiya Okuno <Mikiya] 14775 2009-03-12 10:05 ┗[HIRATSUKA Sadao <hir] -> 14776 2009-03-12 10:20 ┗[HIRATSUKA Sadao <hir] 14777 2009-03-12 19:46 ┗["linux@xxxxxxxxxx" <]