Re: Materialised Views

From: <alistair.thomson_at_sphinxcst.co.uk>
Date: Fri, 04 Feb 2000 14:39:11 GMT
Message-ID: <87eoae$7bl$1@nnrp1.deja.com>

A materialized view is used to summerise data. This could result in a fact table with millions of records being summarised to a MV of thousands of records. The query response time is infinately faster. OLAP tools should also benefit from this if they are reporting directly from the MV.

Alistair Thomson

In article <87e43m$pi7$1_at_gxsn.com>,
"Steven Price" <prices_at_globalnet.co.uk> wrote:
> Has nyone used the new mterialised views and how do they compare to
using an
> OLAP tool
>
> We are building a DW wth fact tables of about 100 million rows which
users
> want to use for ad-hoc analysis.
> There are about 6 dimensions.
>
> Steve
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Feb 04 2000 - 08:39:11 CST