On Fri, 2010-11-05 at 15:46 +0800, Changying Li wrote:
> yes, I tried :
> mysql> explain SELECT forumid,visible,sticky,dateline FROM `abc` WHERE
> `forumid` = 25 AND `visible` = 1 AND `sticky` = 0 order by dateline \G
> *** 1. row ***
>
yes, I tried :
mysql> explain SELECT forumid,visible,sticky,dateline FROM `abc` WHERE
`forumid` = 25 AND `visible` = 1 AND `sticky` = 0 order by dateline \G
*** 1. row ***
id: 1
select_type: SIMPLE
table: abc
type: ref
2010/11/4 Changying Li :
> PRIMARY KEY (`threadid`),
> KEY `dateline` (`dateline`),
> KEY `forumid_2` (`forumid`,`thread_type_id`,`visible`,`sticky`,`dateline`),
> KEY `forumid` (`forumid`,`visible`,`sticky`,`dateline`)
> ) ENGINE=InnoDB AUTO_INCREMENT=660 DEFAULT CHARSET=utf8;
>
> mysql> expla