Home | Previous Page | Next Page   Dimensional Databases > Implementing a Dimensional Database (XPS) >

Indexes for Data-Warehousing Environments

In addition to conventional (B-tree) indexes, Extended Parallel Server provides the following indexes that you can use to improve ad hoc query performance in data-warehousing environments:

To improve indexing efficiency, Extended Parallel Server also supports the following functionality:

An analysis of the types of queries you anticipate running against your database can help you decide the type of indexes to create. For information about indexes and indexing methods that you can use to improve query performance, see your IBM Informix: Performance Guide.

Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]