Review the Queries that will be Optimized (Usage-Based Optimization Wizard)

Use the Review the Queries that will be Optimized page to display and select the queries, retrieved from the query log, which will be used by the Usage-Based Optimization Wizard to design aggregations for the selected partitions.

Options

  • (Select)
    Select the check box of the query that you want to design aggregations for.

  • Client Request
    Displays the members referenced by the displayed query.

  • Occurrences
    Displays the number of occurrences for the displayed query in the query log.

  • Average Duration
    Displays the average duration for all occurrences of the displayed query.