Search Results
https://dev.mysql.com/doc/internals/en/optimizer-transpositions.html
Thus: WHERE 5 = -column1 is not treated the same as: WHERE column1 = -5 Transpositions to expressions of the form column = constant are ideal for index lookups. If an expression of this form refers to an indexed column, then MySQL always uses the ...
https://dev.mysql.com/doc/internals/en/select-special-engines.html
The normal engine can be replaced with such special engines only during the optimization process.
https://dev.mysql.com/doc/ndbapi/en/ndb-ndbrecord.html
You can also use NdbRecord in conjunction with the PartitionSpec structure to perform scans that take advantage of partition pruning, using NdbIndexScanOperation::setBound(). Decription NdbRecord is an interface which provides a mapping to a full or ...
https://dev.mysql.com/doc/ndbapi/en/ndb-table.html
Table::getColumn() Description This method is used to obtain a column definition, given either the index or the name of the column. Return value A pointer to the column with the specified index or name. This section provides information about the ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-config-metric-optimizer-category.html
Eq Range Index Dive Limit Indicates the number of equality ranges in an equality comparison condition when the optimizer switches from using index dives to index statistics in estimating the number of qualifying rows. Lists the Optimizer ...
https://dev.mysql.com/doc/x-devapi-userguide/en/fetching-all-data-items-at-once.html
In addition to the pattern of using fetchOne() explained at Section 9.3, “Working with Data Sets”, which enables applications to consume data items one by one, X DevAPI also provides a pattern using fetchAll(), which passes all data items of a ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/fetching-all-data-items-at-once.html
execute(); var myRows = myResult.fetchAll(); for (index in myRows){ print (myRows[index].name + " is " + myRows[index].age + " years old."); } When mixing fetchOne() and fetchAll() to read from one data set keep in mind that every call to fetchOne() ... In addition to the pattern of using fetchOne() explained at Section 9.3, “Working with Data Sets”, which enables applications to consume data items one by one, X DevAPI also provides a pattern using fetchAll(), which passes all data items of a data set as a list to the ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-rpd-columns-table.html
DATA_PLACEMENT_INDEX The data placement key index ID associated with the column. For information about data placement key index values, see Section 5.8.2, “Data Placement Keys”. For a DATA_PLACEMENT_INDEX query that identifies columns with data ... The rpd_columns table provides column encoding information for columns of tables loaded in MySQL ...
https://dev.mysql.com/doc/heatwave-aws/en/mysql-server-default-privileges.html
Default MySQL Privileges 3.1.2.9 Default MySQL Privileges This section lists the MySQL privileges granted to the MySQL Administrator user on the DB System and those explicitly revoked on the mysql and sys schemas.
https://dev.mysql.com/doc/refman/8.4/en/adding-character-set.html
For each collation listed in the <charset> element for the character set in Index.xml, MYSET.xml must contain a <collation> element that defines the character ordering. For each <collation> element listed in the <charset> element for the character ... This section discusses the procedure for adding a character set to ...