Query Performance

Due to the Hyperstage column-oriented data organization and other Hyperstage-specific features, query optimization in Hyperstage is slightly different than in traditional DBMS approaches.

Temp tables may be used to manage intermediate steps without needing to do database cleanup.

To optimize your query performance, avoid the following, which will result in the query being handled by the PostgreSQL query engine: