Re: Indexing & data warehousing

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