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

Home -> Community -> Usenet -> c.d.o.server -> Re: query help

Re: query help

From: Michael J. Moore <DoNThicamelSPAM_at_comcast.net>
Date: Tue, 27 Jul 2004 02:08:30 GMT
Message-ID: <yOiNc.168479$IQ4.138522@attbi_s02> 





>

> Analytics rock:

>

> SELECT DISTINCT FIRST_VALUE(el1) OVER(PARTITION BY el2 ORDER BY el3) el1,

>                 FIRST_VALUE(el2) OVER(PARTITION BY el2 ORDER BY el3) el2,

>                 FIRST_VALUE(el3) OVER(PARTITION BY el2 ORDER BY el3) el3

>            FROM TEST;


>

> Look at autotrace output: less consistent gets, less sorts

>

> Urs




That is very cool. Now I will go figure out why it works.
Received on Mon Jul 26 2004 - 21:08:30 CDT












Original text of this message













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