adonetok (8/11/2010)
Which one is fast to get count of records?1)select count(*) from order
2)select count(OrderID) from order (OrderID is primary key)
I tested in 3894000 records table but both them are done in 0 second
They'd have the same execution plans I'd imagine, so the same performance in this particular case.