OLAP (On-Line Analytical Processing) functions were first published as an addendum to the ISO SQL:1999 standard, and since have been completely incorporated into both the SQL:2003 and the recently-published SQL:2008 ISO SQL Standards. SQL Anywhere has included OLAP functionality since the 9.0.1 release (February 2004), which comprises grammar and query processing support for: GROUP BY [...]
Entries Tagged as 'Semantic rewrite optimizations'
The Window operator and window aggregate functions
March 31st, 2009 · 1 Comment
Tags: Query optimization · Semantic rewrite optimizations · SQL Anywhere · SQL Standard
Glenn Paulley is a Director of Engineering at Sybase iAnywhere.
