Home Forums SQL Server 2012 SQL Server 2012 - T-SQL why should we use schemabinding with views? RE: why should we use schemabinding with views?

  • July 30, 2013 at 1:17 am

    #1636851

    T.Ashish (2013-07-29)

    A view without any Index, but bound with schema.

    Does it gives any performance difference.

    For a view, no. But for a scalar user-defined function WITH SCHEMABINDING can be important.

    [font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]