Search Results
https://dev.mysql.com/doc/refman/8.4/en/information-schema-optimization.html
To write queries for these tables most efficiently, use the following general guidelines: Try to query only INFORMATION_SCHEMA tables that are views on data dictionary tables. Note Comparison behavior for database and table names in ... Applications ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-materialized-views.html
The following example queries the rpd_table_id table for queries with the airport_US materialized view. This topic describes how to create materialized views on MySQL HeatWave, which is supported as of MySQL 9.5.0. A materialized view is a database ...
https://dev.mysql.com/doc/refman/8.4/en/limit-optimization.html
If you need only a specified number of rows from a result set, use a LIMIT clause in the query, rather than fetching the whole result set and throwing away the extra data. MySQL sometimes optimizes a query that has a LIMIT row_count clause and no ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-nl-sql.html
As of MySQL 9.4.1, MySQL HeatWave GenAI lets you generate SQL queries from natural-language statements, making it easier for you to interact with your databases. This topic describes how to use the NL_SQL routine to generate and run SQL queries ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-nl-sql.html
GenAI lets you generate SQL queries from natural-language statements, making it easier for you to interact with your databases. This topic describes how to use the NL_SQL routine to generate and run SQL queries from natural-language statements.
https://dev.mysql.com/doc/refman/8.4/en/mysqldumpslow.html
The MySQL slow query log contains information about queries that take a long time to execute (see Section 7.4.5, “The Slow Query Log”). Normally, mysqldumpslow groups queries that are similar except for the particular values of number and ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-qanal-using.html
Similar queries with different literal values are combined for reporting purposes. Once the data is collected, you view and monitor the queries, check the execution statistics, and filter and drill down on the information. By comparing the queries ... The MySQL Query Analyzer enables you to monitor SQL statements executed on a MySQL server and displays the details of each query, number of executions and execution ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-using-views.html
This topic describes how to run queries on views using MySQL HeatWave and verify if those queries are offloaded to the MySQL HeatWave secondary engine for accelerated processing. Queries executed on views are subject to the same offload ...Verify ...
https://dev.mysql.com/doc/connectors/en/connector-python-example-cursor-select.html
The following example shows how to query data using a cursor created using the connection's cursor() method. The task is to select all employees hired in the year 1999 and print their names and hire dates to the console. We then create a new ...
https://dev.mysql.com/doc/connector-python/en/connector-python-example-cursor-select.html
The following example shows how to query data using a cursor created using the connection's cursor() method. The task is to select all employees hired in the year 1999 and print their names and hire dates to the console. We then create a new ...