- 5.4.1 Requirements for Running Queries
- 5.4.2 SELECT Statement Clauses for HeatWave
- 5.4.3 Explain Query and Check Execution Time
- 5.4.4 CREATE TABLE ... SELECT Statements
- 5.4.5 Create 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 HeatWave is enabled and the data you want to query is loaded, queries that qualify are automatically offloaded from the DB System to 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 HeatWave Cluster. After 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, HeatWave supports InnoDB partitions. Query processing in HeatWave can access partitions with standard syntax.
For information about connecting to a DB System on HeatWave Service:
For HeatWave on OCI see Connecting to a DB System in the HeatWave on OCI Service Guide.
For HeatWave on AWS, see Connecting from a Client in the HeatWave on AWS Service Guide.