MicroStrategy Optimizations for Vertica

Moderator: NorbertKrupa

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

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

Image

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

Post Reply

Return to “MicroStrategy”