PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.4Kb
Man Pages (Zip)
- 378.4Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
Displaying 81 to 85
of 85 total results
- « Previous
- 7
- 8
- 9
https://dev.mysql.com/doc/refman/9.7/en/mysql-indexes.html
Exceptions: Indexes on spatial data types use R-trees; MEMORY tables also support hash indexes; InnoDB uses inverted lists for FULLTEXT indexes. Indexes are used to find rows with specific column values quickly. Without an index, MySQL must begin ...
https://dev.mysql.com/doc/refman/9.7/en/mysqldump.html
The affected data types are BINARY, VARBINARY, BLOB types, BIT, all spatial data types, and other non-binary data types when used with the binary character set. The mysqldump client utility performs logical backups, producing a set of SQL ...
https://dev.mysql.com/doc/refman/9.7/en/gis-geometrycollection-property-functions.html
If any geometry argument is a syntactically well-formed geometry in an undefined spatial reference system (SRS), an ER_SRS_NOT_FOUND error occurs. Unless otherwise specified, functions in this section handle their geometry arguments as follows: If ...
https://dev.mysql.com/doc/refman/9.7/en/optimizer-statistics.html
The column_statistics table has these characteristics: The table contains statistics for columns of all data types except geometry types (spatial data) and JSON. The column_statistics data dictionary table stores histogram statistics about column ...
https://dev.mysql.com/doc/refman/9.7/en/optimize-table.html
OPTIMIZE TABLE does not sort R-tree indexes, such as spatial indexes on POINT columns. OPTIMIZE TABLE reorganizes the physical storage of table data and associated index data, to reduce storage space and improve I/O efficiency when accessing the ...