COUNT(*) vs COUNT(1) < Eddie Awad’s Blog

COUNT(*) vs COUNT(1)

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

Possibly related:

Tagged count | Post a Comment

Comments (1)

Robert Vollman wrote:
More:
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950\_P8\_DISPLAYID:1156159920245
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950\_P8\_DISPLAYID:1156151916789

Connor McDonald:
http://www.oracledba.co.uk/tips/count\_speed.htm

Jonathan Lewis:
http://www.jlcomp.demon.co.uk/faq/count\_rows.html

Cheers,
Robert
July 6th, 2005, at 12:24 pm #