MicroStrategy Optimizations for Vertica
Posted: Mon Nov 05, 2012 8:55 pm
Vertica-specific SQL Syntax
- CASE expressions
Sub queries
- Union All support
Support for temporary tables
- Vertica function library
- Aggregate awareness with physical summary tables
Middle-tier computation of calculations not available in Vertica
Middle-tier caching via Intelligent Cubes
Report caching