http://blogs.msdn.com/b/ssma/archive/2011/06/20/migrating-oracle-materialized-view-to-sql-server.aspxBy Gowri Shanker and Welly Lee. This blog post discusses approaches to migrate Oracle Materialized View to SQL Server. We compare Materialized View with SQL Server Indexed View, discuss scenarios supported by Indexed View and provide suggestions youen-USTelligent Evolution Platform Developer Build (Build: 5.6.50428.7875)http://blogs.msdn.com/b/ssma/archive/2011/06/20/migrating-oracle-materialized-view-to-sql-server.aspx#10293556Fri, 13 Apr 2012 13:33:49 GMT91d46819-8472-40ad-a661-2c78acb4018c:10293556WQ<p>Why SLQ Server doesn&#39;t allow creating indexed views with subqueries? This is a serious limitation during migration from Oracle.</p> <div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10293556" width="1" height="1">