Question
What is the objective of star-join optimization?
Select an option. Your answer will be checked instantly.
Correct Answer: C. Efficiently filter a large fact table using selective dimension predicates
Explanation:
Star queries combine a very large fact table with smaller dimensions.
Optimizers may use bitmap filters, join reordering, and columnstore techniques to reduce fact rows early.
Leave a Reply