Post reply

Indexed View

  • April 30, 2008 at 8:12 pm

    #185036

    Hey Guyz,

    I have come across a situation where I have to create an Indexed View to test the performance implications rather than going with a redesign which is a significant cost on the business.

    How do I actually go about creating an Indexed View anyways?

    Has anyone got any experience with it? Does the index need to be rebuilt every now and then to cater for the new records?

    Cheers 🙂

    Kindest Regards,

    WRACK
    CodeLake

  • April 30, 2008 at 8:25 pm

    #809416

    May this link help.

    http://msdn.microsoft.com/en-us/library/ms188783.aspx

  • April 30, 2008 at 8:35 pm

    #809417

    So basically all I need to do is,

    CREATE INDEX IX_vw_Test ON dbo.vw_Test

    Kindest Regards,

    WRACK
    CodeLake

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

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