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.
Index prefixes
This option allows the user to specify...
