Page 1 of 1

MicroStrategy Optimizations for Vertica

Posted: Mon Nov 05, 2012 8:55 pm
by JimKnicely
Vertica-specific SQL Syntax
  • CASE expressions
    Sub queries
Multi-pass SQL for analytical sophistication
  • Union All support
    Support for temporary tables
Seamless support for key Vertica features
  • Vertica function library
Extensions to Vertica functionality
  • Aggregate awareness with physical summary tables
    Middle-tier computation of calculations not available in Vertica
    Middle-tier caching via Intelligent Cubes
    Report caching