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. 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.

Running queries and other query-related topics are described in the following sections:

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