• <small id='v6ILr'></small><noframes id='v6ILr'>

    <tfoot id='v6ILr'></tfoot>

  • <i id='v6ILr'><tr id='v6ILr'><dt id='v6ILr'><q id='v6ILr'><span id='v6ILr'><b id='v6ILr'><form id='v6ILr'><ins id='v6ILr'></ins><ul id='v6ILr'></ul><sub id='v6ILr'></sub></form><legend id='v6ILr'></legend><bdo id='v6ILr'><pre id='v6ILr'><center id='v6ILr'></center></pre></bdo></b><th id='v6ILr'></th></span></q></dt></tr></i><div id='v6ILr'><tfoot id='v6ILr'></tfoot><dl id='v6ILr'><fieldset id='v6ILr'></fieldset></dl></div>
      <bdo id='v6ILr'></bdo><ul id='v6ILr'></ul>

  • <legend id='v6ILr'><style id='v6ILr'><dir id='v6ILr'><q id='v6ILr'></q></dir></style></legend>

        索引布尔字段是否有任何性能提升?

        时间:2023-06-26
          <tbody id='TVfgb'></tbody>
          <bdo id='TVfgb'></bdo><ul id='TVfgb'></ul>
          1. <i id='TVfgb'><tr id='TVfgb'><dt id='TVfgb'><q id='TVfgb'><span id='TVfgb'><b id='TVfgb'><form id='TVfgb'><ins id='TVfgb'></ins><ul id='TVfgb'></ul><sub id='TVfgb'></sub></form><legend id='TVfgb'></legend><bdo id='TVfgb'><pre id='TVfgb'><center id='TVfgb'></center></pre></bdo></b><th id='TVfgb'></th></span></q></dt></tr></i><div id='TVfgb'><tfoot id='TVfgb'></tfoot><dl id='TVfgb'><fieldset id='TVfgb'></fieldset></dl></div>
              <legend id='TVfgb'><style id='TVfgb'><dir id='TVfgb'><q id='TVfgb'></q></dir></style></legend>
            • <small id='TVfgb'></small><noframes id='TVfgb'>

            • <tfoot id='TVfgb'></tfoot>

                1. 本文介绍了索引布尔字段是否有任何性能提升?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着跟版网的小编来一起学习吧!

                  问题描述

                  我即将编写一个包含 WHERE isok=1 的查询.顾名思义,isok 是一个布尔字段(实际上是一个 TINYINT(1) UNSIGNED,根据需要设置为 0 或 1).

                  I'm just about to write a query that includes a WHERE isok=1. As the name implies, isok is a boolean field (actually a TINYINT(1) UNSIGNED that is set to 0 or 1 as needed).

                  索引该字段是否有任何性能提升?引擎(在本例中为 InnoDB)查找索引的性能会更好还是更差?

                  Is there any performance gain in indexing this field? Would the engine (InnoDB in this case) perform better or worse looking up the index?

                  推荐答案

                  并非如此.你应该把它当作一本书来思考.如果一本书中只有 3 种单词,并且您将所有单词编入索引,则索引页数将与普通页数相同.

                  Not really. You should think about it like a book. If there were only 3 kinds of words in a book and you index all of them, you would have the same number of index pages as normal pages.

                  如果一个值的记录相对较少,则会提高性能.例如,如果您有 1000 条记录,其中 10 条为 TRUE,那么使用 isok = 1

                  There would be a performance gain if there are relatively few records of one value. For example, if you have 1000 records and 10 of them are TRUE, then it would be useful if you searching with isok = 1

                  正如 Michael Durrant 提到的,它也会使写入速度变慢.

                  As Michael Durrant mentioned, it also makes writes slower.

                  可能的重复:索引布尔字段

                  这里解释了即使您有索引,如果您有太多记录,它也不会使用索引.MySQL 在检查时不使用索引 = 1, 但与 = 0

                  Here it explains that even if you have an index, if you have too many records it doesn't use the index anyways. MySQL not using index when checking = 1 , but using it with = 0

                  这篇关于索引布尔字段是否有任何性能提升?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持跟版网!

                  上一篇:MySql - 更新字符串部分的方法? 下一篇:带有子查询的mysql更新查询

                  相关文章

                2. <tfoot id='tTJ89'></tfoot>

                  • <bdo id='tTJ89'></bdo><ul id='tTJ89'></ul>

                    <small id='tTJ89'></small><noframes id='tTJ89'>

                    <legend id='tTJ89'><style id='tTJ89'><dir id='tTJ89'><q id='tTJ89'></q></dir></style></legend>

                    <i id='tTJ89'><tr id='tTJ89'><dt id='tTJ89'><q id='tTJ89'><span id='tTJ89'><b id='tTJ89'><form id='tTJ89'><ins id='tTJ89'></ins><ul id='tTJ89'></ul><sub id='tTJ89'></sub></form><legend id='tTJ89'></legend><bdo id='tTJ89'><pre id='tTJ89'><center id='tTJ89'></center></pre></bdo></b><th id='tTJ89'></th></span></q></dt></tr></i><div id='tTJ89'><tfoot id='tTJ89'></tfoot><dl id='tTJ89'><fieldset id='tTJ89'></fieldset></dl></div>