Re: Indexing & data warehousing

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. Tim Billy Wheeler wrote: > > On 15 Dec 98, at 12:02, Willem Roos wrote: > > > Could someone please provide pointers to sites/mailing lists/newsgroups > > where one could discuss/obtain design guidelines for data warehouses, > > specifically about indexing. > > > > Do you generally index nearly every column or don't you bother cause you > > won't be able to tell what your average rational data warehouse user is > > going to do next anyway? > > > > Any thoughts? > > In the main, you don't index unless it's for integrity purposes. > > Check out: > > http://www.rkimball.com/ > http://www.data-warehouse.com/ > http://www.dw-institute.com/ > > HTH. > > -- > Ciao, > > Billy > > "I was recently on a tour of Latin America, and the only regret I have was > that I didn't study Latin harder in school so I could converse with those > people" - Former U.S. Vice-President Dan Quayle -- - -- --- Tim Schaefer ---- tschaefe@mindspring.com --- http://www.inxutil.com -- -