Re: Indexing & data warehousing

On 22 Dec 98, at 23:40, Doug Johnson wrote: > I don't think it's quite that simple. You're right of course, and so is Tim. The correct answer was actually "it depends". There is no universal indexing strategy to recommend. But for starters, _I_ would certainly not index anything but integrity and then monitor performance from there, adding indexes as needed. I apologise for making a broad, sweeping statement without clarifying what I actually meant. :-) > 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. > > > > > -- Ciao, Billy Some days it's just not worth chewing through the restraints...