create index OrderDate on Orders (OrderDate, OrderID); select OrderDate, count(OrderID) from Orders o group by OrderDate