SQL 加了Order By超慢,去掉飞快,怎么解决 本帖最后由 sksgod 于 2011-08-28 10:57:01 编辑 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 创建 (BookName, UpTime)的复合索引 参考一下这个贴子。http://topic.csdn.net/u/20110827/17/739bd667-703b-4ca1-89ff-e625e724d00b.html 贴出你的EXPLAIN结果和所有相关表的show index from .. 1 SIMPLE novel_chapter ALL BookName 68522 Using temporary; Using filesort1 SIMPLE novel_booklist ref BookName BookName 130 novel.novel_chapter.BookName 1 1 SIMPLE novel_category ALL CategoryName 8 Using where; Using join buffernovel_chapter 0 PRIMARY 1 ID A 68522 BTREE novel_chapter 1 BookName 1 BookName A 243 YES BTREE novel_chapter 1 BookName 2 UpTime A 68522 YES BTREE novel_chapter 1 BookName 3 ChapterName A 68522 BTREE novel_chapter 1 ID 1 ID A 68522 BTREE novel_chapter 1 ChapterName 1 ID A 68522 BTREE novel_chapter 1 ChapterName 2 ChapterName A 68522 BTREE novel_chapter 1 ChapterName 3 Volume A 68522 YES BTREE novel_chapter 1 ChapterName 4 ChapterLen A 68522 YES BTREE novel_chapter 1 ChapterLen 1 ChapterLen A 68522 YES BTREE novel_chapter 1 UpTime 1 UpTime A 22840 YES BTREE 强制索引select *from A force index(1楼的索引)where ... 烦人的mysql ERROR 2005 错误,是否有人遇到过 靠!见了鬼了,Mysql Varchar(500) 放了700个字符 有没有高手知道MySQL的AES密码是如何生成的? mysql高手帮忙看看,谢谢 讨论一个查询 请问,我下了一个MYSQL,请问我怎么知道它是源文件的还是二进制的?我刚刚刚学LINUX和MYSQL。 mysql 连接问题 MYSQL字符集的问题 查询结果集可以作为表名 数据库优化 FIND_IN_SET 逻辑问题 求一条mysql语句 wamp 2.2 的phpmyadmin 想改成输入密码登陆方式。
1 SIMPLE novel_booklist ref BookName BookName 130 novel.novel_chapter.BookName 1
1 SIMPLE novel_category ALL CategoryName 8 Using where; Using join buffernovel_chapter 0 PRIMARY 1 ID A 68522 BTREE
novel_chapter 1 BookName 1 BookName A 243 YES BTREE
novel_chapter 1 BookName 2 UpTime A 68522 YES BTREE
novel_chapter 1 BookName 3 ChapterName A 68522 BTREE
novel_chapter 1 ID 1 ID A 68522 BTREE
novel_chapter 1 ChapterName 1 ID A 68522 BTREE
novel_chapter 1 ChapterName 2 ChapterName A 68522 BTREE
novel_chapter 1 ChapterName 3 Volume A 68522 YES BTREE
novel_chapter 1 ChapterName 4 ChapterLen A 68522 YES BTREE
novel_chapter 1 ChapterLen 1 ChapterLen A 68522 YES BTREE
novel_chapter 1 UpTime 1 UpTime A 22840 YES BTREE
from A force index(1楼的索引)
where ...