Re: Tom Kyte's book obsolescence

From: Mladen Gogala <>
Date: 02 Feb 2008 15:22:54 GMT
Message-ID: <47a48ace$0$1342$>

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

Original text of this message