Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Re[4]: HI

RE: Re[4]: HI

From: Lex de Haan <lex.de.haan_at_naturaljoin.nl>
Date: Mon, 20 Sep 2004 19:53:57 +0200
Message-ID: <JFEEIGBIDOCCDALDIPLNCENNCIAA.lex.de.haan@naturaljoin.nl>


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.



visit http://www.naturaljoin.nl <http://www.naturaljoin.nl>

skype me <callto://lexdehaan>

-----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-l
Received on Mon Sep 20 2004 - 12:49:33 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US