Re: [sqr-users] Performance help needed - where the time goes?

["George Jansen" <GJANSEN@aflcio.org>]

Yelena,

(or Ms. Kontorovich, if you prefer), the best reference for the
"analytic functions" is in the Oracle Data Warehousing Guide, which you
should be able to download from http://technet.oracle.com. 

Briefly, without the analytic functions, expressions in a row of a
query's result set can only use values in precisely that row; with the
analytic functions, they can use expressions values in other rows: the
first, the last, the previous, several others, etc. This makes some real
economies possible--SQL can be cleaner and faster.

I attach a presentation I have given at a couple of  regional users
group meetings.

George Jansen


Here was a non admissible message part of
'application/vnd.ms-powerpoint' MIME type. It has been automatically
discarded before sending the message to the list.