Re: Tom Kyte's book obsolescence
Date: 02 Feb 2008 15:22:54 GMT
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.Received on Sat Feb 02 2008 - 09:22:54 CST