Post reply

Indexing a view

  • August 12, 2013 at 12:20 pm

    #281048

    I'm using a SQL view to retrieve data from 8 different tables without having to do 8 select statements.

    This has sped my project up quite a bit over the 8 selects.

    But I still have some users complaining that it is slow.

    Is it possible to index a view to improve its performance?

  • August 12, 2013 at 12:35 pm

    #1640671

    why not using Indexed Views functionality?

  • August 12, 2013 at 12:45 pm

    #1640677

    This might help you.

    http://technet.microsoft.com/en-us/library/dd171921%28v=sql.100%29.aspx

  • August 12, 2013 at 12:53 pm

    #1640680

    Thank you!. I think this is going to work for me.

    The guys that work for me don't seem to like views, but I find that they make writing the SQL much easier.

  • August 12, 2013 at 1:25 pm

    #1640695

    Chris, can you post the CREATE VIEW statement? Better still, can you post an actual execution plan (as a .sqlplan attachment) of a select from the 'slow' view?

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

  • August 12, 2013 at 2:58 pm

    #1640712

    x

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

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