Post reply

How Can we Create Indexed Views In Sql Server 2005

  • February 22, 2012 at 10:06 am

    #265036

    Hi all,

    How can we create indexed views in sql server 2005.. Can anybody Please assist me....:-)

    Thanks in Advance.. .

    🙂

  • February 22, 2012 at 10:09 am

    #1450424

    My first question before I try answering such a broad question, have you looked up indexed views in Books Online?

  • February 22, 2012 at 10:13 am

    #1450427

    Now i am Doing the Same, Mean while I posted it.....

  • February 22, 2012 at 10:22 am

    #1450434

    Will these indexed views improves the Performance..?

  • February 22, 2012 at 11:06 am

    #1450462

    Here comes the consultant answer (wait for it ...)

    It Depends.

    Now that we have that out of the way, what edition of SQL Server 2005 are you using?

  • February 23, 2012 at 8:09 am

    #1450887

    SqlSpider... (2/22/2012)

    Will these indexed views improves the Performance..?

    They can, but it really depends on what you're doing it for, what kind of data is underneath, etc. If you're reading up on them in the BOL, then you should be seeing some warnings suggesting that they're not that useful for volatile data, meaning if your data is changing a lot. It's true. If your data is in serious flux, you might be better off with a permanent table instead of an indexed view, but based on what you've provided, it's impossible to suggest that this might be a better solution, just something for you to keep in mind.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • February 24, 2012 at 8:24 am

    #1451440

    you have to use SCHEMABINDING

    http://technet.microsoft.com/en-us/library/cc917715.aspx

Viewing 7 posts - 1 through 6 (of 6 total)

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