dbTalk Databases Forums  

Re: Index and View

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Re: Index and View in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Jéjé
 
Posts: n/a

Default Re: Index and View - 12-11-2006 , 07:45 AM






I'm not sure if I understand your question...
A view is based on tables, if the tables change, then the view content
change too !!!

Do you talk about SQL based views (views created in the database) or DSV
named queries?
In both cases the result is near the same, but using views coming from the
database allow you to change your business logic without impacting the cubes
(for example, you decide to split or merge tables, your change the view used
by the cube and the cube continue to works correctly)

Also views don't contain indexes, but the tables behind the view generally
use indexes.
In SQL Server 2005 Enterprise you can create indexed views, but if its for
load a cube, indexed views will not really helps you (the time taken to
create the index in this view is an overhead, specially if the view is
designed to fill a cube)
Indexed views are great for grouping queries like "select col1, col2,
count(*) from tables... group by col1, col2"

Remember that a MOLAP cube (default type of cube) will read everything from
the database and store it locally on the SSAS server. so the source database
is not read anymore after you have done your process. So optimizing the
database don'T help the user access but can help the processing time.

"MIB" <MIB (AT) discussions (DOT) microsoft.com> wrote

Quote:
Hi,
I was looking to Real Project, and even if i can understand why we should
use view for the UDM, i'm very surprised to see that the view doesn't
contain
any Index. Why?
I thought that to use idex for view will increase performance like for a
table.
If i'm using a view, should i do something to update data from my view
(and
then from my dimension)?
Thanks


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.