SQL Intermediate 01

Question 1 of 43

--:--

Progress 2%

Question 1

A table Orders has 50M rows. Queries frequently filter by OrderDate and CustomerID. Which indexing strategy is most appropriate?

Separate indexes on OrderDate and CustomerID

Composite index on (OrderDate, CustomerID)

Composite index on (CustomerID, OrderDate)

No index, rely on full table scans

Exit

Help keep QuizFlow free and running! Your support makes a difference Consider donating today Every contribution helps Help keep QuizFlow free and running! Your support makes a difference

Support Us