You can test whether reflections that you created are used to satisfy a query without actually running the query. This practice can be helpful when the tables are very large and you want to avoid processing large queries unnecessarily.
To test whether one or more reflections are used by a query:
- In the side navigation bar, click the SQL Runner icon.
- In the SQL editor, type
EXPLAIN PLAN FORand then type or paste in your query.
- Click the Run button.
- When the query has finished, click the Run link found directly above the query results to view the job details. Any reflections used will be shown on the page.