In Oracle, there are at least three different ways to count the number of records a SQL query returns:

Which one to use? COUNT(*) or COUNT(1)? Tom Kyte’s answer.