Re: A question about Indexing.

From: a_blonde@mindless.com > > ---- 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. Ah, but you use IDS AD/XP for "Data Warehouses" and operational data stores, and the Wiffly Other Thing for data marts. > > 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. :-) ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com