CREATE INDEX IX_User_Email ON Users(Id) INCLUDE (Email, CreatedAt)
Why this matters
-
Eliminates key lookups
-
Massive speedups for read-heavy queries
Bits of .NET
Daily micro-tips for C#, SQL, performance, and scalable backend engineering.