Re: Designing a Reporting Database

I'm wondering about the speed of an indexed view as compared to an indexed table. I am already leaning towards the indexed view (just from a maintenance/development standpoint) but I'd like to see the actual numbers. If you have an idea or know where I could find out, I'd really appreciate it.

"BP Margolin" <bpmargo_at_attglobal.net> wrote in message news:<3b0d425f_1_at_news3.prserv.net>...

> Todd,
>
> When I mentioned OLAP I wasn't specifically talking about Analysis Services,
> although I can certainly see the confusion. OLAP applications have been
> implemented on relational platforms, so I was asking whether the application
> itself was originally OLTP, and now the same set of tables are being
> considered for DSS / OLAP purposes.
>
> It this is indeed the case, then I would certainly suggest, as I mentioned
> in the earlier post, seriously considering not hosting both OLTP and DSS /
> OLAP applications on the same server in the same database.
>
> SQL Server 2000 does indeed support indexed views.
>
> -------------------------------------------
> BP Margolin
> Please reply only to the newsgroups.
> When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc.) which
> can be cut and pasted into Query Analyzer is appreciated.
Received on Sun Jul 22 2001 - 01:26:09 CEST