Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-auto-indexing-execution.html
Autopilot Indexing provides recommendations for schemas with a representative workload that has at least five queries in the SQL statement digest history in the Performance Schema. Autopilot Indexing only evaluates SQL statements in the SQL ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-arithmetic-operators.html
All arithmetic operators are supported with variable-length encoded string columns, see Section 5.8.1.4, “Encoding String Columns”.
https://dev.mysql.com/doc/heatwave/en/mys-hw-async-apptask-kill.html
The kill_app_task routine kills an active or scheduled task using its task ID. Syntax mysql> SELECT mysql_tasks.kill_app_task( IN 'app_user_id' VARCHAR(255), IN 'task_id' VARCHAR(36); Following are kill_app_task parameters: app_user_id ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-async-exec.html
As of MySQL 9.3.1, you can run SQL statements as asynchronous tasks that run in the background. This lets your current session to continue without waiting for these SQL statements or tasks to complete. It is particularly helpful for long-running ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-comparison-functions-operators.html
The VARLEN Support column identifies functions and operators that support variable-length encoded string columns. Table 5.3 Comparison Functions and Operators Name VARLEN Support Description BETWEEN ... Yes Check whether a value is within a range of ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-create-table-select.html
This topic describes how to create a new table and insert data using a SELECT query. When the query is offloaded to MySQL HeatWave, it is processed faster, improving the overall performance of the operation. SELECT statement is not permitted when ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-flow-control-functions-operators.html
The VARLEN Support column identifies functions and operators that support variable-length encoded string columns.
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-authenticate-service.html
Note If the dynamic group belongs to the default identity domain, you can omit specifying the identity domain name. GroupName: the dynamic group name CompartmentID: the compartment ID of the DB system For more information, see Resource Principals.
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-chat-details.html
This topic describes how to view a chat session details. It contains the following sections: Before You Begin View Details What's Next Before You Begin Complete the steps to run MySQL HeatWave Chat. View Details To view the chat session details, ...
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 feature collects information on the schemas, tables, and columns that you have ...