COUNT(*) vs COUNT(1)
Which one to use? COUNT(*) or COUNT(1)? Tom Kyte’s answer.
Related articles:
- Different ways to count
- Found or Not Found, That is The Question. Do You Have The Answer?
- SQL PLUS Gotcha
Which one to use? COUNT(*) or COUNT(1)? Tom Kyte’s answer.
Related articles:
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