Re: Tom Kyte's book obsolescence
From: Mladen Gogala <mgogala_at_yahoo.com>
Date: 02 Feb 2008 15:22:54 GMT
Message-ID: <47a48ace$0$1342$834e42db@reader.greatnowhere.com>
Date: 02 Feb 2008 15:22:54 GMT
Message-ID: <47a48ace$0$1342$834e42db@reader.greatnowhere.com>
On Sat, 02 Feb 2008 15:10:14 +0000, Jonathan Lewis wrote:
> It's your memory that is mostly at fault. The book says:
> "DEPENDING ON various factors, such as the size of the table and the
> number of rows you expect to get back, this MAY BE more efficient
> than making two passes to achieve the same goal".
Thank you Jonathan! You are right, as usual. It is a HASH GROUP BY vs. SORT GROUP BY.
-- http://mgogala.freehostia.comReceived on Sat Feb 02 2008 - 09:22:54 CST