Chronicling Life, Love, Linux and Oracle database administration.
05 January 2007
selecting count(1) vs count(*)
Count me among the many who naively assumed that using count(1) instead of count(*) was somehow faster or less resource-intensive when counting the number records in a select query. Herod over at Yet Another Oracle DBA provides some more evidence on top of Tom Kyte's previous smackdown.