Community Learn Tools Library Leisure
search
English
Home > Backend Development > PHP Tutorial > body text

请问板板 为什么有些字段索引后反而更加影响查询速度

WBOY
Release： 2016-06-23 13:41:15
Original
930 people have browsed it

请问板板 为什么有些字段索引后反而更加影响查询速度


回复讨论(解决方案)

索引不会渐慢查询速度，但会影响插入和修改的速度

加了索引只?>=?加索引的查?速度。不?比不加慢的。
但?影?插入和更新速度。

你??情?估?是服?器CPU?用不同?致。

Related labels：
请问板板 为什么有些字段索引后反而更加影响查询速度
source：php.cn
Previous article：关于微店整合微信支付时出现的的各种问题的记录 php版 Next article：php 中这个用法的浮点运算的函数是什么
Statement of this Website
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
Latest Articles by Author
Latest Issues
function_exists() cannot determine the custom function Function test () {return true;} if (function_exists ('test')) {echo "test is function...
From 2024-04-29 11:01:01
0
2
1915
How to display the mobile version of Google Chrome Hello teacher, how can I change Google Chrome into a mobile version?
From 2024-04-23 00:22:19
0
10
2090
The child window operates the parent window, but the output does not respond. The first two sentences are executable, but the last sentence cannot be implemented.
From 2024-04-19 15:37:47
0
1
1758
There is no output in the parent window document.onclick = function(){ window.opener.document.write('I am the output of the child ...
From 2024-04-18 23:52:34
0
1
1661
Where is the courseware about CSS mind mapping? Courseware
From 2024-04-16 10:10:18
0
0
1668
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template