Which of the following technique is not used in performance improvement in star schema?

Options
- Maintaining multiple fact tables to represent different aggregation levels
- Partitioning and replicating tables
- De normalizing fact tables
- Normalizing fact tables

CORRECT ANSWER : Normalizing fact tables

Discussion Board
Performance improvement in Star schema

Star schema performance improvements include an improved detection algorithm and a new join method. The improved star schema detection algorithm allows the query optimizer to detect queries based on star schema and employ star schema specific strategies to improve performance for those queries. In addition, to improve performance of queries using the star schema in data warehouse and data mart environments, the new zigzag join method can be used to join one or more fact tables with two or more dimension tables.

Prajakta Pandit 03-17-2017 07:10 AM

Write your comments


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)


Related Content

Advertisement
 
▲