Re: Indexing & data warehousing

I don't think it's quite that simple. 1. Informix uses lots of indexes for their TPC-D benchmarks. 2. The Data Warehouse Optimizer will (soon?) recommend a set of indexes based on analysis of MetaCube query audits. 3. GK indexes (bit map, join, etc.) can significantly reduce query elapsed times and resource consumption when selectivity is less than 1 in 1000. Physical scans of fragmented tables can burn up every processor in the cluster. Tim Schaefer wrote in message <367F9484.21BC0B84@mindspring.com>... >Billy is right on the money. > >If you use Informix XPS, Informix recommends to avoid using indexes on anything. >As a practical matter, in the XPS world indexes also interfere with loading. >