Re: A question about Indexing.

---- you wrote: > From: a_blonde@mindless.com > > > >Unless you speak to ex-RedBrick (now Informix) consultants Dude. They > >insist a Data Warehouse needs RI! But that might be because they have a > >star index, and ADO does not. > > Last time I looked, we were discussing the Database Server For Real Men With > Hairy Chests (TM), not that wiffly other thing. :-) Sure Dude, but I was just pointing out that there are two schools of thought when it comes to DW DB design, and Informix subscribe to both of them. > But (horror of horrors!) that chap Townsend from the O-word Corporation was > basically right. When you're in AD/XP territory, the normal rules of > database design don't really apply. I mean, ask any ex-RedBrick consultant > how they would cope with putting RI onto a database where the _raw_data_ > exceeded 2TB... :-) Sure thing, but Informix still support & sell it for some reason. Though sometimes I think they just bought it to remove an irritation from the market. Perhaps they could rename it to IDS-RHO - IDS Red Herring Option, or maybe IDS-LBO - Lead Brick(Baloon) Option. AB ---------------------------------------------------------------- Get your free email from AltaVista at http://altavista.iname.com