What are the advantages in creating an indexed view?



-----Original Message-----
From: Rahool Moray [mailto:[Email Address Removed] Wednesday, December 31, 2003 1:04 AM
To: LazyDBA.com Discussion
Subject: Re: Indexed Views


create view ViewName as
select * from TableName (index=IndexName_you_want_to_use)

This view will always get you indexed data.


-----------------------------------------------
Rahool Moray
IT Specialist
vMoksha Technolgies Ltd
+91 20 4121454
-----------------------------------------------
----- Original Message -----
From: "Mandeep Bhutani" <[Email Address Removed] "LazyDBA.com Discussion" <[Email Address Removed] Wednesday, December 31, 2003 11:09 AM
Subject: Indexed Views


> Hi All,
>
> Can anybody please tell me the syntax to create an
> Indexed View??
>
> Thanks and Regards
> Mandeep
>
> __________________________________
> Do you Yahoo!?
> Free Pop-Up Blocker - Get it now
> http://companion.yahoo.com/
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> Get today's cartoon: http://www.LazyDBA.com
> To unsubscribe, e-mail: mssqldba-[Email Address Removed] For additional commands, e-mail: mssqldba-[Email Address Removed]

---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Get today's cartoon: http://www.LazyDBA.com
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page