Physical reads are probably meaningless but pay attention to:
COUNT(*):
CPU: Elapsed:
12.46 12.53
COUNT(1):
CPU: Elapsed:
12.38 12.40
This might be the 100th time I am having this debate about COUNT(*) and COUNT(ROWID)
:-)
|
Results 1 to 10 of 25
Thread: Using ROWID in SQL queriesThreaded View
|
Click Here to Expand Forum to Full Width |