Post reply

Schemabind view

  • January 8, 2010 at 11:05 am

    #136355

    Hi,

    How views with schemabinding is refreshed? At the time the table(s) are updated (or has a row inserted or deleted)? How it degraded the performance if the values of the tables are a lot changed?

    Does anyone know that? I couldn't find anything regarding the refresh on schemabind views.

    Thanks

  • January 8, 2010 at 11:10 am

    #1101076

    Please don't cross post.

    Replies should be directed to:

    http://www.sqlservercentral.com/Forums/Topic844263-360-1.aspx

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • January 8, 2010 at 11:17 am

    #1101084

    edited to avoid crossposting the post as Jason suggested. see the original thread.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply