Skip to main content

Viewing Whether Queries Used Reflections

You can view the list of jobs on the Jobs page to find out whether queries were accelerated by reflections. The Jobs page lists the jobs that ran queries, both queries from your data consumers and queries run within the Dremio or Dremio Cloud user interface.


To find whether a query used a reflection:

  1. Find the job that ran the query by looking below the details in each row.
  2. Look for the indicator that one or more reflections were used. The Duration field includes an orange flame after the duration of the query.
  3. View the job summary by clicking the ID of the job that ran the query.

Relationships between Reflections and Jobs

The relationship between a job and a reflection can be one of the following types:

  • CONSIDERED: the reflection is defined on a dataset that is used in the query but was determined to not cover the query (for example the reflection did not have a field that is used by the query).

  • MATCHED: a reflection could have been used to accelerate the query but Dremio determined that it would not provide any benefits or another reflection was determined to be a better choice.

  • CHOSEN: a reflection is used to accelerate the query. Note that multiple reflections can be used to accelerate queries.