Re: 2 million row database from hell! help a newbie in over his head.
From: David Cressey <david_at_dcressey.com>
Date: Thu, 23 Aug 2001 00:05:23 GMT
Message-ID: <7NXg7.301$Iw2.19807_at_petpeeve.ziplink.net>
Date: Thu, 23 Aug 2001 00:05:23 GMT
Message-ID: <7NXg7.301$Iw2.19807_at_petpeeve.ziplink.net>
Mikito,
> Is there built-in index that would make this query fast? With group by? I
was
> assuming that the whole data warehousing mumble has been around because
> databases are so index-challenged.
It seems to me that the logical structure of data marts, never mind data warehouses, is different from the logical structure of transaction processing systems. As far as modeling goes, I'd say that dimensional modeling is a radical departure from E-R modeling.
Add to that the fact that warehouses are designed to outlast the systems that feed them, and you have some really different challenges than the ones facing operational databases.
> 8.1.7
-- Regards, David Cressey www.dcressey.comReceived on Thu Aug 23 2001 - 02:05:23 CEST