- 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;
推薦閱讀
- Practical DevOps
- 新編Premiere Pro CC從入門到精通
- Mastering C# Concurrency
- Bootstrap 4:Responsive Web Design
- 網絡爬蟲原理與實踐:基于C#語言
- Learn React with TypeScript 3
- C++新經典
- Julia高性能科學計算(第2版)
- Unity 2018 Shaders and Effects Cookbook
- Mastering C++ Multithreading
- Hands-On Full Stack Development with Spring Boot 2.0 and React
- 深入實踐Kotlin元編程
- Learning Ionic
- 大數據時代的企業升級之道(全3冊)
- Building Clouds with Windows Azure Pack