- 5.4.1 Requirements for Running Queries
- 5.4.2 SELECT Statement Clauses for MySQL HeatWave
- 5.4.3 Explain Query and Check Execution Time
- 5.4.4 CREATE TABLE ... SELECT Statements
- 5.4.5 Create MySQL HeatWave Temporary Tables
- 5.4.6 INSERT ... SELECT Statements
- 5.4.7 Query Views
- 5.4.8 View Query Runtimes and Estimates
- 5.4.9 Diagnose Query Offload
- 5.4.10 Auto Scheduling
- 5.4.11 Auto Query Plan Improvement
- 5.4.12 Dynamic Query Offload
When MySQL HeatWave is enabled and the data you want to query is loaded, queries that qualify are automatically offloaded from the DB System to MySQL HeatWave for accelerated processing. No special action is required. Simply run the query from a client, application, or interface that is connected to the DB System associated with the MySQL HeatWave Cluster. After MySQL HeatWave processes a query, results are sent back to the DB System and to the client, application, or interface that issued the query.
As of MySQL 9.1.0, MySQL HeatWave supports InnoDB partitions. Query processing in MySQL HeatWave can access partitions with standard syntax.
For information about connecting to a DB System on MySQL HeatWave Service:
For MySQL HeatWave on OCI see Connecting to a DB System in the MySQL HeatWave on OCI Service Guide.
For MySQL HeatWave on AWS, see Connecting from a Client in the MySQL HeatWave on AWS Service Guide.