Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
venkath
Posting Yak Master
202 Posts |
 Posted - 2008-10-07 : 06:32:48
|
| Hi allI am required to create an indexed view on a query which has LEFT OUTER JOIN.But I can not add an index on Indexed view.It sayscannot create index on view "DB.dbo.VIEW_GROUP2" because it uses a LEFT, RIGHT, or FULL OUTER join, and no OUTER joins are allowed in indexed views. Consider using an INNER join instead.Is there a way I can write a query with out left outer join to achieve the left outer join functionality?Thanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-07 : 06:43:03
|
| as error suggests you cant create indexed view when view defnition involves outer join. change it to inner join if you can |
 |
|
|
|
|
|
Unable to add index on Indexed view