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 2:51 am

    #1636878

    Erland Sommarskog (7/30/2013)

    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.

    As it's one of the conditions to make UDF deterministic.

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]