InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
What Is Aggregate Awareness? How Do You Use This? |
|
Answer» Using aggregate awareness, you can use pre-aggregated data in tables in the database. It is used to improve query performance by PROCESSING LESS number of ROWS. When you add an aggregate aware object in query, query generator retrieves the data from table with HIGHEST aggregation LEVEL. Example − Consider a Sales Fact table where sales is aggregated by per month. If your query asks for sales per month, query generator will retrieve the data from aggregated table. Using aggregate awareness, you can use pre-aggregated data in tables in the database. It is used to improve query performance by processing less number of rows. When you add an aggregate aware object in query, query generator retrieves the data from table with highest aggregation level. Example − Consider a Sales Fact table where sales is aggregated by per month. If your query asks for sales per month, query generator will retrieve the data from aggregated table. |
|