Re: Indexes, Materialized Views and Data Marts.

From: Howard J. Rogers <howardjr2000_at_yahoo.com.au>
Date: Sat, 26 Oct 2002 15:13:23 +1000
Message-ID: <Knpu9.62575$g9.176293@newsfeeds.bigpond.com>

"Barry" <barryw_at_databaseanswers.com> wrote in message news:55816d8a.0210251542.7d8b8aea_at_posting.google.com...
> Hi Experts,
>
> Can I create indexes on Materialized Views ?

Yes. At the end of the day, they're tables.

Regards
HJR
>
> Is there any accepted Best Practice for moving data from a Data
> Warehouse, (star schema), through a normalised Database into Data
> Marts, which might be defined in Business Objects ?
>
> I will be very grateful for any thoughts.
>
> TIA
Received on Sat Oct 26 2002 - 00:13:23 CDT