Home >Database >Mysql Tutorial >mysql 目录原理
mysql 目录原理
- WBOYOriginal
- 2016-06-07 16:25:061213browse
mysql 索引原理 对于 这条 SQL: from message where id=1 and name='a' ??mysql最后是如何找到数据的呢？? 是先匹配id=1的索引，然后再匹配name=a的索引，最后再merge，还是同时判断？ ? http://www.fuzzy.cz/en/articles/basic-principles-of-database-index
mysql 索引原理对于这条SQL:
from message where id=1 and name='a'
??mysql最后是如何找到数据的呢？?
是先匹配id=1的索引，然后再匹配name=a的索引，最后再merge，还是同时判断？
?
http://www.fuzzy.cz/en/articles/basic-principles-of-database-indexes/
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：MySQL正则表达式使用MySQL系列（4）Next article：Mysql 起动时报 Checking for tables which need an upgrade, ar