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 ...
(SQL Server 2000)<BR><BR>I have a query that basically selects a lot of "complicated" stuff and then dumps it into a #temp table.<BR><BR>I then have a correlated subquery that runs against the temp ...
Results that may be inaccessible to you are currently showing.
Hide inaccessible results
Feedback