Share via

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

  • Article

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

Options

  • (Select)
    Select the check box in the column heading to design aggregations for all displayed queries.

    Select the check box for a query to design aggregations for just the selected query.

  • 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 occurences of the displayed query.

See Also

Reference

Usage-Based Optimization Wizard F1 Help (SSAS)
Analysis Services Wizards (SSAS)

Help and Information

Getting SQL Server 2005 Assistance