-----Original Message----- > From: Niall Litchfield > > Standard edition should be just fine if you don't > > need partitioning > > and function-based indexes > Small correction > Function Based Indexes are available in std edition > from 9.2 There are a number of other > previously EE only options that have > sneaked in in this release. > Cheers > Niall Litchfield 9.2 Std Ed: Analytic Functions available. reviewing statspack data for (new) server sizing requirements, LAG/LEAD OVER ( PARTITION BY ORDER BY) sure is sweet. I need not say anymore, but to quote that much material, I have to add in an additional amount of ballast. A few more lines ought to do it. --------------------------------------------------- http://www.groklaw.net/ I sure would like to see a Celebrity Deathmatch between Linus and Darl ---------------------------------------------------- __________________________________ Do you Yahoo!? Yahoo! Small Business $15K Web Design Giveaway http://promotions.yahoo.com/design_giveaway/ ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------