Skip to main content
Hitachi Vantara Lumada and Pentaho Documentation

Query Optimization

Note: This section is still in progress. The information below is accurate, but may be insufficient.

Indexing is a major factor in query performance, and is one valid way of solving the high-cardinality dimension problem without redesigning the data warehouse. Have your database administrator review your database configuration and ensure that large dimensions and measures are properly indexed.