2.3 Running Queries

2.3.1 Query Prerequisites

2.3.2 Running Queries

2.3.3 Auto Scheduling

2.3.4 Auto Query Plan Improvement

2.3.5 Debugging Queries

2.3.6 Query Runtimes and Estimates

2.3.7 CREATE TABLE ... SELECT Statements

2.3.8 INSERT ... SELECT Statements

2.3.9 Using Views

When HeatWave is enabled and the data you want to query is loaded, queries that qualify are automatically offloaded from the MySQL 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 MySQL DB System and to the client, application, or interface that issued the query.

As of MySQL 8.4.0, HeatWave supports InnoDB partitions. Query processing in 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.

For related best practices, see Section 2.9, “Best Practices”.