Here at Guidewire we are considering using Common Table Expressions, which are now supported in SQL Server and Oracle. I know this is on the to-do list already. Any work going on in this area?
On Thursday, August 5, 2010 3:16:10 PM UTC-7, Thomas Kellerer wrote: > > On Aug 2, 2:31 pm, Thomas Mueller <[email protected]> > wrote: > > You have a serious complexity problem here. > > No I don't ;) > > These are aggregating reports that do some pretty nifty aggregation & > calculation on a daily basis. And in order to re-use the intermediate > results CTEs are very useful. > Views are not really an option as each of those CTEs is passed a > parameter (the calculation runs in a stored procedure). Using the > parameters directly in the CTE is a bit faster than applying the > corresponding WHERE clause to a generalized view. > > But as Dario says: that's not the point. CTEs *are* useful, and it > would be nice if H2 supported them as well. > > Thomas > > > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
