Re: GROUP BY optimization headscratcher

---+ +--+-+ Thanks so much! -Matt -Original Message----- From: ÃÃ ÃÂÃ [mailto:[EMAIL PROTECTED] Sent: Saturday, August 14, 2004 3:46 AM To: Matt Eaton Subject: Re: GROUP BY optimization headscratcher ÐÐÑÐÐÑÑÐÑÐÑÐ Matt ME> CREATE TABLE `T1`

RE: GROUP BY optimization headscratcher

Message- From: ÃÃ ÃÃÃÃÃÂÃ [mailto:[EMAIL PROTECTED] Sent: Saturday, August 14, 2004 3:46 AM To: Matt Eaton Subject: Re: GROUP BY optimization headscratcher ÐÐÑÐÐÑÑÐÑÐÑÐ Matt ME> CREATE TABLE `T1` ( ME> `guid` smallint(5) unsigned NOT NULL default '0', ME> `qid` small

Re: GROUP BY optimization headscratcher

Здравствуйте Matt ME> CREATE TABLE `T1` ( ME> `guid` smallint(5) unsigned NOT NULL default '0', ME> `qid` smallint(5) unsigned NOT NULL default '0', ME> `a` tinyint(2) NOT NULL default '-2', ME> `d` tinyint(2) NOT NULL default '-2', ME> KEY `IX_FW_qid` (`qid`), ME> KEY `IX_FW_d` (`d`)

GROUP BY optimization headscratcher

Hi all. Got a weird one. Mysql 4.0.20. Let's say for the sake of argument that I've got two tables, T1 & T2. Here are the two create statements: CREATE TABLE `T1` ( `guid` smallint(5) unsigned NOT NULL default '0', `qid` smallint(5) unsigned NOT NULL default '0', `a` tinyint(2) NOT NULL