Hi All,Can anybody please tell me the syntax to create anIndexed View??Thanks and RegardsMandeep__________________________________Do you Yahoo!?Free Pop-Up Blocker - Get it nowhttp://companion.yahoo.com/MS Sql Server LazyDBA home page