Especially on large tables.
Why it happens
Full scan required.
Tip
Use metadata counts when possible.
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.
Especially on large tables.
Why it happens
Full scan required.
Tip
Use metadata counts when possible.