Red Brick STARjoin technology leverages referential integrity relationships in a star or snowflake schema and uses STAR indexes to provide industry-leading query performance and scalability. Additional B-Tree indexes may be created by an administrator on other columns for increased query performance. The Red Brick server can re-evaluate and adjust the execution plan of a query, at run time, based on information obtained from intermediate results. This feature, coupled with the Red Brick technology for parallelism and parallel on demand, helps maximize query efficiency and system throughput. A key component of the Red Brick server is Red Brick Vista , a comprehensive, server-integrated solution for aggregate computation and management.
Aggregate computation is an important component of decision support applications.
In large data warehouse environments, aggregate query processing can be computationally intensive. Vista provides an effective strategy for achieving exceptional query performance through the use of precomputed aggregates while minimizing the costs associated with creating and maintaining such aggregates. The Vista query rewrite component automatically rewrites queries on detail data to use precomputed aggregates. This transparent rewrite function allows end users, query tools, and application programmers to derive the performance advantages of aggregates without having to change queries and applications. The Advisor component of Vista aids the DBA in determining an optimal set of aggregates required to satisfy a system s unique performance and space requirements.