NAV 2009, Indexed Views and SQL Server 2008 Standard

sbranin
sbranin Member Posts: 18
edited 2009-10-14 in SQL Performance
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

Comments

  • Slawek_Guzek
    Slawek_Guzek Member Posts: 1,690
    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
    Slawek Guzek
    Dynamics NAV, MS SQL Server, Wherescape RED;
    PRINCE2 Practitioner - License GR657010572SG
    GDPR Certified Data Protection Officer - PECB License DPCDPO1025070-2018-03
  • sbranin
    sbranin Member Posts: 18
    Thanks for the quick answer to my question.

    -Steve

Categories