What do you understand by the term 'Aggregate Advisor?'

Aggregate Advisor help in increasing the overall performance.

• It is a component of the Dynamic Query Analyzer
• It can be Support database either in-memory aggregate or aggregate tables or maybe both.
• Aggregate Advisor utilize statistics and cube’s model
• Aggregate Advisor utilize workload log files which are available from the execution of reports
• To recover the summed value and put the values in their specific aggregate cache so that they can be used for query processing, aggregate execute the important SQL statement after the cube restart.
• It works during the off-peak meanwhile in the non-critical business hours