Connect with a community of experts and enthusiasts on IDNLearn.com. Get the information you need from our community of experts, who provide detailed and trustworthy answers.

You have a large fact table with many columns and the table is being used by many analytical queries. Which of the following is the best index strategy in general?
A. Rowstore index
B. Columnstore index
C. No index
D. B-tree index