* Jesse Sheidlower [...] > CREATE TABLE `citation_subject` ( > `id` int(11) NOT NULL auto_increment, > `citation_id` int(11) NOT NULL default '0', > `subject_id` int(11) NOT NULL default '0', > PRIMARY KEY (`id`), > KEY `citation_id` (`citation_id`,`subject_id`) > )
Try adding an index with subject_id as the first column. ALTER TABLE `citation_subject` ADD INDEX (`subject_id`,`citation_id`); -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]