Multiple choice technology databases

which one is the advantage of datawarehouse?

  1. less joins

  2. more indexes

  3. both

  4. none
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Data warehouses use denormalized schemas (star and snowflake schemas) which reduce the number of joins needed for queries. They also create numerous indexes to optimize query performance on large datasets. Both fewer joins and more indexes are key architectural advantages that enable fast analytical queries.

Keep practicing — related questions