如题CREATE TABLE `score` ( `id` int(11) NOT NULL, `
如题
CREATE TABLE `score` (
`id` int(11) NOT NULL,
`studentid` int(11) NOT NULL,
`subjectid` int(11) NOT NULL,
`score` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- 新建一个索引能够同时提升三条sql的查询性能
ALTER TABLE `score` ADD INDEX `score` ( `score` , `studentid` , `subjectid` )
EXPLaiN SELECT * FROM score WHERE score=100;
EXPLAIN SELECT * FROM score WHERE studentid=5 AND score=100;
EXPLAIN SELECT * FROM score WHERE studentid=5 AND subjectid=2 AND score=100;
`
--结束END--
本文标题: 新建一个索引能够同时提升三条SQL的查询性能
本文链接: https://www.lsjlt.com/news/37831.html(转载时请注明来源链接)
有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341
下载Word文档到电脑,方便收藏和打印~
2024-05-15
2024-05-15
2024-05-15
2024-05-15
2024-05-15
2024-05-15
2024-05-15
2024-05-15
2024-05-15
2024-05-15
回答
回答
回答
回答
回答
回答
回答
回答
回答
回答
0