Home
Data warehousing
In addition to designing and implementing Informix® dimensional databases, you can use tools to create data warehouse applications and optimize your data warehouse queries.
Dimensional databases
The Informix® Data Warehouse Guide provides information to help you design, implement, and manage dimensional databases, and describes the tools that you can use to create data warehouses and optimize your data warehouse queries.
Performance tuning dimensional databases
This section describes how to tune the performance of your queries and to understand data distribution statistics.

Data warehousing
In addition to designing and implementing Informix® dimensional databases, you can use tools to create data warehouse applications and optimize your data warehouse queries.
- Dimensional databases
  The Informix® Data Warehouse Guide provides information to help you design, implement, and manage dimensional databases, and describes the tools that you can use to create data warehouses and optimize your data warehouse queries.
  - Dimensional databases
    A dimensional database is a relational database that uses a dimensional data model to organize data. This model uses fact tables and dimension tables in a star or snowflake schema.
  - Design a dimensional data model
    To build a dimensional database, you start by designing a dimensional data model for your business.
  - Implement a dimensional database
    You will learn the SQL statements that you need to implement the dimensional data model
  - Performance tuning dimensional databases
    This section describes how to tune the performance of your queries and to understand data distribution statistics.
    - Query execution plans
      When a SELECT statement or other DML operation is submitted to the database server, the query execution optimizer designs a query execution plan. The query execution optimizer is often referenced as the query optimizer.
    - Data distribution statistics
      Data distribution statistics are stored in the system catalog for use by the query optimizer when it designs query execution plans. These statistics, together with other information, enable the optimizer to estimate the relative costs among the execution plans that the optimizer is considering for a specific query. Distribution statistics that the optimizer examines for tables that are referenced in queries can include column distribution statistics for the table and for its indexes, as well as fragment-level statistics, if the database server has gathered statistics for individual table or index fragments.
- Informix® Warehouse Accelerator
  The Informix® Warehouse Accelerator Administration Guide includes information about installing and configuring the accelerator server, creating data marts, accelerators, and accelerated query tables (AQTs).

Performance tuning dimensional databases

This section describes how to tune the performance of your queries and to understand data distribution statistics.