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
CREATE TABLE `abc` (
`threadid` int(11) NOT NULL AUTO_INCREMENT COMMENT '主题id',
`thread_type_id` int(11) DEFAULT NULL COMMENT '主题类别表id',
`forumid` smallint(6) DEFAULT NULL COMMENT '主键id',
`title` varchar(250) DEFAULT NULL COMMENT '标题',
`lastpost` int(11) DEFAULT NULL COMMENT '最后回复时间',
