This query scans rows:
SELECT COUNT(*) FROM Orders;
✅ Faster Metadata Count (Approximate)
SELECT SUM(row_count)
FROM sys.dm_db_partition_stats
WHERE object_id = OBJECT_ID('Orders')
AND index_id IN (0,1);
Use when
-
Dashboards
-
Monitoring
-
Large tables