Re: Is OLAP essentially for Large Enterprises

From: Puneet Agarwal <NOSPAM__puneetagarwal_at_india.com>
Date: Mon, 29 Oct 2001 00:41:17 +0530
Message-ID: <9rhl58$tfc3b$1@ID-99266.news.dfncis.de>

Do you mean that Materialized vews which are based on aggregate tables are also optimized. Please elaborate further or refer me a resource where I can find more information. I could not find much regarding optimization of aggregate based view in SQL Server books online.

Thanks
"Umachandar Jayachandran" <umachandar_at_yahoo.com> wrote in message news:Ot#wSA#XBHA.2184_at_tkmsftngp05...
> No. Not from within the RDBMS itself. Whereas if you use indexed or
> materialized views, this is possible.
>
> --
> Umachandar Jayachandran
> SQL Resources at http://www.umachandar.com/resources.htm
> ( Please reply only to newsgroup. )
>
>
Received on Sun Oct 28 2001 - 13:11:17 CST