What are Aggregate Awareness and Index Awareness? Where are they used and how can be used? - BO Designer

What are Aggregate Awareness and Index Awareness? Where are they used and how can be used?

Aggregate Awareness:

- Information is persisted in database as a summary form.

- The data warehouse store the quantity of data each hour / day / week.

- Aggregations are used
1. to save the space of storage media.
2. to improve the performance of BI tool – Queries takes less time to process, thus users obtain the information quickly.

Index Awareness:

- The ability to take the advantage of the indexes of key columns for quick data retrieval.

- Set up the Index awareness in BO Designer by specifying the database primary and foreign key columns.

- SQL is generated by the BO Designer, for filtering the most efficient way, by using Index Awareness.