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 Dynamic Query Offload

2.3.6 Debugging Queries

2.3.7 Query Runtimes and Estimates

2.3.8 CREATE TABLE ... SELECT Statements

2.3.9 INSERT ... SELECT Statements

2.3.10 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 MySQL 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 9.1.0, HeatWave supports InnoDB partitions. Query processing in HeatWave can access partitions with standard syntax.

For information about connecting to a MySQL 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.

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