September 3, 2004 at 9:38 am
Can someone confirm if you have successfully been able to use indexed views in SQL Server 2000 Standard Edition? I know I have gotten it to work in the past, but I can’t do it right now. Is it possible this behavior has changed since service pack 3?
I can create the indexed view, build a clustered index, but when I run it with the NOEXPAND option (which forces the optimizer to use the indexed view and is required to get it to work in Standard Edition) the optimizer doesn’t use it. The execution plan ignors the NOEXPAND.
September 6, 2004 at 3:46 am
Nuppers! It won't work in standard edition.
Standard edition will allow you to create the index on the view, for compatibility reasons, but only Enterprise Edition will actually use it.
As someone else was asking earlier, you may restore a database from Enterprise to a Standard server. In which case SQL has to allow the view index to be created.
Julian Kuiters
juliankuiters.id.au
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply