Re: A question about Indexing.

From: a_blonde@mindless.com > > ---- you wrote: > > 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. > >Sure Dude, that's what Informix marketing came up with in order to sell the >products side by side. The Red Herring people were not too happy about that >concept though. Just as the ADO people were not too happy about their >product not being sutiable for data marts. Why do you think ADO for NT was >dropped, hey? A direct competitor for Lead Balloon. I think the number one reason AD/XP isn't suitable for data marts is the $150 000 installation and configuration price tag. :-) >I think they should stop pandering to the Red Balloon people, and drop it >in favour of ADO on all platforms! It's a cool product! The problem they >have is they don't have a marketing dept who can sell that concept to the >public. Wrong. You should have said: "The problem they have is they don't have a marketing dept." Full stop. Anyway, I don't know that they should drop either one if they can sell them. They each address different things, and *I* don't believe that the song and dance of setting up AD/XP is justified in a lot of smaller sites. Also, LeadBrik is very fast in specific cases, and that might make it attractive to certain people. Informix is still a long way from a "one size fits all" database, IMHO. ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com