| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Re[4]: HI
actually, although the optimizer is one of my hobbies,
and I happen to know a little bit about the Oracle optimizer,
in this case I am mainly interested in language elegance
and not in performance, for a change ;-)
but anyway, I am indeed looking for GROUP BY statements
(completely specified, including data structures and constraints)
to check whether they can be rewritten without a GROUP BY.
not only correlated subqueries in the SELECT clause come to mind,
but also the analytical functions applied on row windows
(both features being fully ANSI/ISO standard, by the way)
could be a joint project with you, Jonathan...
Kind regards,
Lex.
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Jonathan Gennick
Sent: Monday, September 20, 2004 18:20
To: Lex de Haan
Cc: oracle-l_at_freelists.org
Subject: Re[4]: HI
Monday, September 20, 2004, 12:03:30 PM, Lex de Haan
(lex.de.haan_at_naturaljoin.nl) wrote:
LdH> By the way, I think we should get rid of the GROUP BY alltogether --
SQL has
LdH> much more powerful and elegant constructs to achieve the same results.
think
LdH> about correlated subqueries in the SELECT clause.
That's a fascinating thought, actually. I'll have to sit down sometime and line up all the uses I can think of for GROUP BY, and see whether I can solve those problems without GROUP BY. It'd be interesting to just run some tests of both approaches, to compare their relative efficiency, even if only in one implementation (e.g. Oracle).
Best regards,
Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:jonathan@gennick.com
Join the Oracle-article list and receive one
article on Oracle technologies per month by
email. To join, visit
http://five.pairlist.net/mailman/listinfo/oracle-article,
or send email to Oracle-article-request_at_gennick.com and
include the word "subscribe" in either the subject or body.
-- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-lReceived on Mon Sep 20 2004 - 12:49:33 CDT
 |
 |