Re: Melbourne Masterclass

From: Yong Huang <yong321_at_yahoo.com>
Date: 1 Aug 2002 14:08:30 -0700
Message-ID: <b3cb12d6.0208011308.5a72701f@posting.google.com>

norwoodthree_at_my-deja.com (NorwoodThree) wrote in message news:<ba03e2c.0207311331.5516d4c7_at_posting.google.com>...
> Yes, and I'm pretty damn sure he'll be peddling his Quest products.

Since his book is not that bad, I still have respect for him. But has anyone reproduced his experiment in the book (pp.204-5, 1st ed.) showing the difference between select count(*) and select count(0)? His execution plan in tkprof indicates that count(*) gives a SORT AGGREGATE on 0 rows (i.e. no sort aggregate), while count(0) and count(customer_id) both show SORT AGGREGATE on 5151 rows.

Yong Huang Received on Thu Aug 01 2002 - 16:08:30 CDT