RE: sort aggregate vs sort order by

2001-12-28 Thread Larry Elkins
Jack, I assume you are asking this question in reference to the access path, or explain plan, for a query. Sort (Aggregate) -- Query returns a single row using a summary function but does not include a GROUP BY clause. Sort (Order By) -- Query includes an ORDER BY clause. Sort (Group By) -- Qu

RE: sort aggregate vs sort order by

2001-12-31 Thread nlzanen1
Hi Larry THX Jack "Larry Elkins" <[EMAIL PROTECTED]>@fatcity.com on 28-12-2001 14:25:18 Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Jack, I assum