Re: Slow view needs optimization help

From: <stevemg_at_gmail.com>
Date: 31 May 2005 10:50:15 -0700
Message-ID: <1117561815.219152.128750@f14g2000cwb.googlegroups.com>

I briefly glanced over this I would look into the analytic sql functions such as

SUM(val) OVER(PARTITION BY key)
LAG(val,1) OVER(PARTITION BY key)

If you go to http://www.oracle.com/technology/books/10g_books.html download the sample chapters from the book Expert Oracle, Signature Edition, im pretty sure one of the chapters in there is on analytic sql.

Analytic SQL is real powerful and can be a lot more effecient than traditional sql methods. Received on Tue May 31 2005 - 12:50:15 CDT