CREATE INDEX idx_active_users ON Users(Id) WHERE IsActive = 1;
Why it matters
Index only what you query.
Bits of .NET
Daily micro-tips for C#, SQL, performance, and scalable backend engineering.
Daily micro-tips for C#, SQL, performance, and scalable backend engineering.
CREATE INDEX idx_active_users ON Users(Id) WHERE IsActive = 1;
Why it matters
Index only what you query.