I'm using MSSQL Server 2008 R2 and I'm trying to optimize my Views when I stumbled upon Indexed Views. Unfortunately most of my Views use a Left Outer Joins which is not supported with Indexed Views. After a bunch of research, I'm left confused the best way to go about this. The way I see it, I have the following options:I'm using MSSQL Server 2008 R2 and I'm trying t