MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 101 to 107 of 107 total results

« Previous
9
10
11
Next »

https://dev.mysql.com/doc/refman/8.0/en/switchable-optimizations.html

The subquery is not an ANY or ALL subquery which can be rewritten to use MIN() or MAX(). Its value is a set of flags, each of which has a value of on or off to indicate whether the corresponding optimizer behavior is enabled or disabled. This ...

10.2.1.23 Avoiding Full Table Scans

https://dev.mysql.com/doc/refman/8.0/en/table-scan-avoidance.html

Start mysqld with the --max-seeks-for-key=1000 option or use SET max_seeks_for_key=1000 to tell the optimizer to assume that no key scan causes more than 1,000 key seeks. The output from EXPLAIN shows ALL in the type column when MySQL uses a full ...

13.2.9 2-Digit Years in Dates

https://dev.mysql.com/doc/refman/8.0/en/two-digit-years.html

Some functions like MIN() and MAX() convert a YEAR to a number. Date values with 2-digit years are ambiguous because the century is unknown. Such values must be interpreted into 4-digit form because MySQL stores years internally using 4 digits. For ...

7.1.9 Using System Variables

https://dev.mysql.com/doc/refman/8.0/en/using-system-variables.html

To restrict the maximum value to which a system variable can be set at runtime with the SET statement, specify this maximum by using an option of the form --maximum-var_name=value at server startup. For example, to prevent the value of ... The MySQL ...

27.5.3 Updatable and Insertable Views

https://dev.mysql.com/doc/refman/8.0/en/view-updatability.html

Some views are updatable and references to them can be used to specify tables to be updated in data change statements. That is, you can use them in statements such as UPDATE, DELETE, or INSERT to update the contents of the underlying table. Derived ...

10.2.1.21 Window Function Optimization

https://dev.mysql.com/doc/refman/8.0/en/window-function-optimization.html

windowing_use_high_precision has no effect on MIN() and MAX(), which do not use inverse aggregation in any case. Window functions affect the strategies the optimizer considers: Derived table merging for a subquery is disabled if the subquery has ...

14.20.2 Window Function Concepts and Syntax

https://dev.mysql.com/doc/refman/8.0/en/window-functions-usage.html

However, whereas an aggregate operation groups query rows into a single result row, a window function produces a result for each query row: The row for which function evaluation occurs is called the current row. The query rows related to the current ...