MYSQL 8 Administrator's Guide by Chintan Mehta

Author:Chintan Mehta
Language: eng
Format: epub
Publisher: Packt
Published: 2018-02-14T14:14:08+00:00

Column-level indexing

MySQL 8 allows you to create an index on a single column, as well as on multiple columns. The maximum number of indexes per table and maximum index length depend on the storage engine. Mostly, all the storage engines allow at least 16 indexes per table and total index lengths of at least 256 bytes, but most of the storage engines permit higher limits.

Column indexes

This is the most common way to define an index where only a single column is involved. MySQL 8 stores a copy of column values in a data structure so that rows can be accessed quickly. MySQL 8 uses a B-Tree data structure to enable values to be accessed quickly. The B-Tree execution will work based on operators, such as =, <, >, BETWEEN, IN, and many more, which were defined in the where condition. You can get details on the B-Tree data structure and its execution in the next topic. We will discuss the characters of column indexes in the coming sections.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.