Home >Database >Mysql Tutorial >mysql 左连接时在不考虑where条件下主表可以使用索引吗
mysql 左连接时在不考虑where条件下主表可以使用索引吗
- WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOriginal
- 2016-06-06 09:35:241869browse
mysql
这是我explain下的分析结果，就差主表没有使用索引了：
主表有30万数据，副表数据上千。全部使用左连接关联5个表查询时5秒以上。希望大神给指个路,思路就行 >
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：mac-Mac系统安装mysql，终端登录报Access denied for user rootNext article：新手求解 怎么在mysql中创建多级表结构