Other Index Questions

Question 1

What is a ColumnStore Index?

Answer 1

Columnstore indexes are the standard for storing and querying large data warehousing fact tables

Question 2

What benefits does a ColumnStore Index give you?

Answer 2

• Better data compression for very large tables
• Query Processing give up to 10x faster results
• Handles inserts well

Question 3

What do ColumnStore not do well?

Answer 3

Updates and Deletes to data

Question 4

What are the benefits to a B-Tree Index?

Answer 4

• keeps keys in sorted order for sequential traversing. *uses a hierarchical index to minimize the number of disk reads.
• uses partially full blocks to speed up insertions and deletions.

Question 5

When is a Hash index useful?

Answer 5

With a memory-optimized Table