Ok, so I'm reading about Indexed Views and I see that another feature of Enterprise edition is that it can substitute them into a standard query when the query optimizer runs the query if it so ...
Oracle has a similar feature called Materialized Views. Indexed Views were introduced in SQL Server 2000 as an Enterprise Edition feature. The confusion arose in SQL Server 2005 when it appeared that ...
I'm using bcp to dump large quantities of data into a table that has several indexed views built on top of it. It seems to work fine for a while, but on ...