Search Results
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 ...
https://dev.mysql.com/doc/x-devapi-userguide/en/collection-indexing.html
The name parameter is required and must be a valid index name as accepted by the SQL statement CREATE INDEX. To make large collections of documents more efficient to navigate you can create an index based on one or more fields found in the ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/collection-indexing.html
The name parameter is required and must be a valid index name as accepted by the SQL statement CREATE INDEX. To make large collections of documents more efficient to navigate you can create an index based on one or more fields found in the ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/collection-indexing.html
The name parameter is required and must be a valid index name as accepted by the SQL statement CREATE INDEX. To make large collections of documents more efficient to navigate you can create an index based on one or more fields found in the ...
https://dev.mysql.com/doc/refman/8.4/en/sys-schema-object-index.html
The following tables list sys schema objects and provide a short description of each one.
https://dev.mysql.com/doc/refman/8.4/en/index-btree-hash.html
For example, the following SELECT statements use indexes: SELECT * FROM tbl_name WHERE key_col LIKE 'Patrick%'; SELECT * FROM tbl_name WHERE key_col LIKE 'Pat%_ck%'; In the first statement, only rows with 'Patrick' <= key_col < 'Patricl' are ...LIKE ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-secondary-indexes.html
A secondary index defined on a virtual column is sometimes referred to as a “virtual index”. A secondary index may be created on one or more virtual columns or on a combination of virtual columns and regular columns or stored generated columns.
https://dev.mysql.com/doc/refman/8.4/en/column-indexes.html
For additional information about column indexes, see Section 15.1.15, “CREATE INDEX Statement”. Note Prefix limits are measured in bytes, whereas the prefix length in CREATE TABLE, ALTER TABLE, and CREATE INDEX statements is interpreted as ...
https://dev.mysql.com/doc/refman/8.4/en/descending-indexes.html
MySQL supports descending indexes: DESC in an index definition is no longer ignored but causes storage of key values in descending order. Previously, indexes could be scanned in reverse order but at a performance penalty. A descending index can be ...
https://dev.mysql.com/doc/refman/8.4/en/invisible-indexes.html
MySQL supports invisible indexes; that is, indexes that are not used by the optimizer. The feature applies to indexes other than primary keys (either explicit or implicit). ALTER INDEX operation: ALTER TABLE t1 ALTER INDEX i_idx INVISIBLE; ALTER ...