官术网_书友最值得收藏!

  • MySQL 8 for Big Data
  • Shabbir Challawala Jaydip Lakhatariya Chintan Mehta Kandarp Patel
  • 111字
  • 2021-08-20 10:06:04

Supporting invisible indexes

MySQL 8 provides you with a feature to make indexes invisible. These kind of indexes cannot be used by the optimizer. In case you want to test the query performance without indexes, using this feature you can do so by making them invisible rather than dropping and re-adding an index. This is a pretty handy feature when indexing is supposed to be dropped and recreated on huge datasets.

All indexes are visible by default. To make them invisible or visible, INVISIBLE and VISIBLE keywords are used respectively, as described in the following code snippet:

ALTER TABLE table1 ALTER INDEX ix_table1_col1 INVISIBLE;
ALTER TABLE table1 ALTER INDEX ix_table1_col1 VISIBLE;
主站蜘蛛池模板: 马边| 岳池县| 辽宁省| 方正县| 花莲县| 宽城| 洛宁县| 中牟县| 施秉县| 中牟县| 深水埗区| 莱阳市| 屏东市| 湖口县| 建湖县| 镇平县| 台东县| 玉环县| 博客| 甘洛县| 朝阳区| 松江区| 浠水县| 越西县| 象州县| 安宁市| 额尔古纳市| 疏附县| 石狮市| 桐梓县| 潜江市| 焦作市| 平邑县| 静乐县| 如东县| 西丰县| 阳泉市| 双柏县| 凤翔县| 华宁县| 修武县|