NAV 2009, Indexed Views and SQL Server 2008 Standard

sbranin

The Edition Comparison chart at Microsoft says that SQL Server 2008 Standard does not support Indexed Views.

http://www.microsoft.com/sqlserver/2008 ... mpare.aspx

I am running NAV2009 on SQL Server 2008 standard and wondering if this is impacting my performance.

The same comparison chart for SQL Server 2005
http://www.microsoft.com/sqlserver/2005 ... tures.aspx
Says that "Indexed view creation is supported in all editions. Indexed view matching by the query processor is supported only in Enterprise Edition.

What would this mean in the context of NAV?

-Steve

Slawek_Guzek

It means nothing.

NAV always adds NOEXPAND table hint to query referring VSIFT view, which enforces using VSIFT view (and clustered index created by NAV on it). This makes VSIFT technology working on all SQL server versions, but also prevents taking full advantage of Indexed Views when NAV runs on Enterprise version of SQL.

By 'taking full advantage' I mean picking by SQL Query Optimizer some alternative index on VSIFT view, if such an index was created manually by DBA

Slawek

sbranin

Thanks for the quick answer to my question.

-Steve