- 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;
推薦閱讀
- 深入淺出Prometheus:原理、應用、源碼與拓展詳解
- MATLAB 2020 從入門到精通
- R語言游戲數據分析與挖掘
- Practical DevOps
- SEO智慧
- Instant RubyMotion App Development
- Advanced Oracle PL/SQL Developer's Guide(Second Edition)
- IBM Cognos Business Intelligence 10.1 Dashboarding cookbook
- Access 2010中文版項目教程
- Managing Microsoft Hybrid Clouds
- PrimeFaces Blueprints
- Webpack實戰:入門、進階與調優(第2版)
- Hadoop大數據分析技術
- 算法設計與分析:基于C++編程語言的描述
- 精通Oracle 12c 數據庫管理