On this page

    Testing Reflections

    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 physical datasets are very large and you want to avoid processing large queries unnecessarily.

    Procedure

    To test whether one or more reflections are used by a query:

    1. In the side navigation bar, click the SQL Runner icon.
    2. In the SQL editor, type EXPLAIN PLAN FOR and then type or paste in your query.
    3. Click the Run button.
    4. 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.