MicroStrategy Optimizations for Vertica

Moderator: NorbertKrupa

Post Reply
User avatar
Site Admin
Site Admin
Posts: 1825
Joined: Sat Jan 21, 2012 4:58 am

MicroStrategy Optimizations for Vertica

Post by JimKnicely » Mon Nov 05, 2012 8:55 pm

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
Jim Knicely


Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.

Post Reply

Return to “MicroStrategy”