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:
- Find the job that ran the query by looking below the details in each row.
- Look for the indicator that one or more reflections were used. The Duration field includes an orange flame after the duration of the query.
- View the job summary by clicking the row that represents the job that ran the query. The job summary appears in the pane to the right of the list of jobs.
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.