Search Results
https://dev.mysql.com/doc/refman/8.4/en/create-index.html
CREATE INDEX is mapped to an ALTER TABLE statement to create indexes. When the innodb_stats_persistent setting is enabled, run the ANALYZE TABLE statement for an InnoDB table after creating an index on that table. However, prefix lengths for index ... CREATE [UNIQUE | FULLTEXT | SPATIAL] INDEX index_name [index_type] ON tbl_name (key_part,...) [index_option] [algorithm_option | lock_option] ...
https://dev.mysql.com/doc/refman/8.4/en/multiple-column-indexes.html
MySQL can create composite indexes (that is, indexes on multiple columns). If you specify the columns in the right order in the index definition, a single composite index can speed up several kinds of queries on the same table. Note As an ...For ...
https://dev.mysql.com/doc/refman/8.4/en/show-index.html
These two statements are equivalent: SHOW INDEX FROM mytable FROM mydb; SHOW INDEX FROM mydb.mytable; The optional EXTENDED keyword causes the output to include information about hidden indexes that MySQL uses internally and are not accessible by ...
https://dev.mysql.com/doc/refman/8.4/en/cache-index.html
| ALL } The CACHE INDEX statement assigns table indexes to a specific key cache. The key cache referred to in a CACHE INDEX statement can be created by setting its size with a parameter setting statement or in the server parameter settings. For more ...| tbl_name PARTITION (partition_list) } IN key_cache_name tbl_index_list: tbl_name [{INDEX|KEY} (index_name[, index_name] ...)] partition_list: { partition_name[, partition_name] ...
https://dev.mysql.com/doc/refman/8.4/en/load-index.html
| ALL } The LOAD INDEX INTO CACHE statement preloads a table index into the key cache to which it has been assigned by an explicit CACHE INDEX statement, or into the default key cache otherwise. tbl_index_list: tbl_name [PARTITION (partition_list)] ...
https://dev.mysql.com/doc/refman/8.4/en/drop-index.html
This statement is mapped to an ALTER TABLE statement to drop the index. algorithm_option: ALGORITHM [=] {DEFAULT | INPLACE | COPY} lock_option: LOCK [=] {DEFAULT | NONE | SHARED | EXCLUSIVE} DROP INDEX drops the index named index_name from the table ...The table is not locked against access from other NDB Cluster API nodes, although it is locked against other operations on the same API node for the duration of the ...
https://dev.mysql.com/doc/refman/8.4/en/glossary.html
Cardinality can also apply to the number of distinct values present in multiple columns, as in a composite index. See Also column, composite index, index, index hint, persistent statistics, random dive, selectivity, unique constraint. Index changes ...adaptive hash index An optimization for InnoDB tables that can speed up lookups using = and IN operators, by constructing a hash index in ...
https://dev.mysql.com/doc/ndbapi/en/ndb-index.html
Index Class Overview Index Class Constructor Index::addColumn() Index::addColumnName() Index::addColumnNames() Index::getColumn() Index::getLogging() Index::getName() Index::getNoOfColumns() Index::getObjectStatus() Index::getObjectVersion() ...It ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-fulltext-index.html
A full-text index is defined as part of a CREATE TABLE statement or added to an existing table using ALTER TABLE or CREATE INDEX. Full-text indexes are created on text-based columns (CHAR, VARCHAR, or TEXT columns) to speed up queries and DML ...To ...
https://dev.mysql.com/doc/refman/8.4/en/index-hints.html
(For the general syntax for specifying tables in a SELECT statement, see Section 15.2.13.2, “JOIN Clause”.) The syntax for referring to an individual table, including index hints, looks like this: tbl_name [[AS] alias] [index_hint_list] ...This ...