Search Results
https://dev.mysql.com/doc/x-devapi-userguide/en/collection-indexing.html
To make large collections of documents more efficient to navigate you can create an index based on one or more fields found in the documents in the collection. Creating an Index Collection indexes are ordinary MySQL indexes on virtual columns that ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/collection-indexing.html
To make large collections of documents more efficient to navigate you can create an index based on one or more fields found in the documents in the collection. Creating an Index Collection indexes are ordinary MySQL indexes on virtual columns that ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/collection-indexing.html
To make large collections of documents more efficient to navigate you can create an index based on one or more fields found in the documents in the collection. Creating an Index Collection indexes are ordinary MySQL indexes on virtual columns that ...
https://dev.mysql.com/doc/refman/8.4/en/create-table.html
| {FULLTEXT | SPATIAL} [INDEX | KEY] [index_name] (key_part,...) [index_option] ... | [CONSTRAINT [symbol]] UNIQUE [INDEX | KEY] [index_name] [index_type] (key_part,...) [index_option] ... (Some valid select or union statement) CREATE TABLE creates ...
https://dev.mysql.com/doc/refman/8.4/en/column-indexes.html
The most common type of index involves a single column, storing copies of the values from that column in a data structure, allowing fast lookups for the rows with the corresponding column values. The B-tree data structure lets the index quickly ...
https://dev.mysql.com/doc/refman/8.4/en/gis-general-property-functions.html
The functions listed in this section do not restrict their argument and accept a geometry value of any type. Unless otherwise specified, functions in this section handle their geometry arguments as follows: If any argument is NULL, the return value ...
https://dev.mysql.com/doc/refman/8.4/en/gis-point-property-functions.html
A Point consists of X and Y coordinates, which may be obtained using the ST_X() and ST_Y() functions, respectively. These functions also permit an optional second argument that specifies an X or Y coordinate value, in which case the function result ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-columns-table.html
The related ST_GEOMETRY_COLUMNS table provides information about table columns that store spatial data. The COLUMNS table has these columns: TABLE_CATALOG The name of the catalog to which the table containing the column belongs. TABLE_SCHEMA The ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-4.html
Account Management Notes C API Notes Character Set Support Compilation Notes Component Notes Firewall Notes Installation Notes Optimizer Notes Performance Schema Notes Functionality Added or Changed Bugs Fixed Account Management Notes The database ...
https://dev.mysql.com/doc/workbench/en/wb-sql-editor-navigator.html
The Navigator area of the sidebar contains options to manage the active MySQL connection. It also lists the schemas on the server for that connection. To access the Navigator area, open an existing connection (or create a new connection) from the ...