Post reply

Indexs on Views (Do the call to a view uses index on a containing table)

  • April 30, 2009 at 12:45 pm

    #133821

    Hi

    I have created a view on my server A which is caling a table from Server B. The table that its calling has a bunch of index on it. Now I want to know does a call to this view, considers the indexes on my table on server B. Its taking a lot of time to respond so I am thinking its not considering the indexes but pls shed some light on it. I am not very good with Views and Indexes.

    Have something like this on server A

    Create view history

    as

    Select * from ServerB.siq.dbo.History

    Also I am using the link Server to links serverA to ServerB

    Please help

    Thanks

    -Sarah

  • April 30, 2009 at 1:04 pm

    #986870

    madamcurie2005 (4/30/2009)

    Hi

    I have created a view on my server A which is caling a table from Server B. The table that its calling has a bunch of index on it. Now I want to know does a call to this view, considers the indexes on my table on server B. Its taking a lot of time to respond so I am thinking its not considering the indexes but pls shed some light on it. I am not very good with Views and Indexes.

    Have something like this on server A

    Create view history

    as

    Select * from ServerB.siq.dbo.History

    Also I am using the link Server to links serverA to ServerB

    Please help

    Thanks

    -Sarah

    Without a "WHERE" clause on the queries interrogating the view this is very likely to be slow.

    How do the queries that use the view look like?


    * Noel

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

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