Bits of .NET

SELECT COUNT(*) FROM Orders

Why COUNT(*) is faster

• Doesn’t check for NULL

• Uses metadata when possible

Avoid COUNT(column) unless required.