Post reply

SCHEMABINDING VIEWS WHICH USES DISTRIBUTED QUERY

  • December 24, 2009 at 9:48 am

    #218980

    CAN WE SCHEMABIND THE VIEWS WHICH USES DISTRIBUTED QUERY?

    Any help will be really appreciated.

    Thanks,

  • December 24, 2009 at 10:29 am

    #1096353

    SchemaBinding can only be used with views that only reference objects within the same database. Referenced objects can be tables, views and user defined functions.

    For views that use distributed queries, SchemaBinding may not be used.

    SQL = Scarcely Qualifies as a Language

  • December 28, 2009 at 8:55 am

    #1096713

    Thank you very much for your reply

    So does that mean we can not improve the performance of the view which is referencing objects from other servers?

    To explain this better,

    I have two views

    --> first view - References one database object from one server

    --> Second View - References two different databases from two different servers.

    when both are run individually, they get executed effeciently in 7 seconds and 26 seconds respectively.

    But when i made another view which combies both the views through inner join for retreiving a specific result set, it takes about (9 AND 1/2 MINUTES) to bring the result set.

    that is the reason why i was thinking of schmabinding the view and then creating indexes on the views so they could run faster, but it seems creating unique clustered index on it is not possible as per above.

    So can you please throw some light on this as to what could be a solutions for this as i think that when both views are running fine individually, it should not take that much time when combined.

    I have also looked at the execution plan, there is one remote query which takes 70% of execution time, but i am not sure what would be the best way to address it.

    Any help will be appreciated.

    Thanks,

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

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