From the course: Oracle HeatWave MySQL Foundations

Unlock this course with a free trial

Join today to access over 25,600 courses taught by industry experts.

Debugging queries

Debugging queries

From the course: Oracle HeatWave MySQL Foundations

Start my 1-month free trial Buy for my team

Debugging queries

“

(warm music) - [Instructor] Welcome to this lesson on debugging queries that cannot run on HeatWave. It covers the steps to identify the reason why a query is not offloaded to the HeatWave cluster for execution. There are many reasons why a query is not offloaded to the HeatWave cluster for execution. The first reason is that the HeatWave cluster has failed or stopped working. The second reason is that at least one of the tables accessed by the query is not loaded into the HeatWave cluster. The query also cannot be offloaded to the HeatWave cluster if a column accessed by the query is excluded from the RAPID secondary engine, A query is not offloaded to the HeatWave cluster if the optimizer estimates that the query execution cost will be less than the HeatWave query cost threshold. A query cannot be offloaded to the HeatWave cluster if it uses an unsupported predicate, function, operator, or has encountered some other limitation of HeatWave. The optimizer trace can be used to identify…

Contents