π§ Covering & Filtered Indexes
π§ Coming soon: INCLUDE lists and WHERE filters for targeted workloads.
-- Placeholder
CREATE INDEX IX_Orders_Open
ON dbo.Orders (CustomerID)
INCLUDE (OrderDate, TotalDue)
WHERE Status = 'Open';
π§ Coming soon: INCLUDE lists and WHERE filters for targeted workloads.
-- Placeholder
CREATE INDEX IX_Orders_Open
ON dbo.Orders (CustomerID)
INCLUDE (OrderDate, TotalDue)
WHERE Status = 'Open';