Question
When is a traditional rowstore B-tree usually preferable to columnstore?
Select an option. Your answer will be checked instantly.
Correct Answer: D. Highly selective point lookups and small-row transactional access
Explanation:
Rowstore indexes efficiently navigate to a small number of matching rows.
Columnstore is optimized more strongly for broad analytical scans.
Leave a Reply