Post reply

execution plan - remote query

  • December 22, 2011 at 5:55 am

    #265341

    i see in the execution plan tat remote query is taking 32% how can we reduce this?

    Thanks

    Ami

  • December 22, 2011 at 5:58 am

    #1424745

    Are you querying to Linked Server tables?

  • December 22, 2011 at 6:06 am

    #1424750

    yes they are linked servers.

  • December 22, 2011 at 6:22 am

    #1424760

    I am afraid you can’t tune remote queries much (subject to my limited knowledge).

    Connect to second server (which you are using as Linked Server) and perform query optimization tricks. At least make sure your indexing strategy is good.

    As a side note, if you hitting Linked Server multiple times for query / stored procedure, load the data in temporary tables for the session.

  • December 23, 2011 at 3:38 pm

    #1425287

    Are you JOINING the remote tables? Please show the code you are running and attach the execution plan.

    Sorry, but you're not really giving us a lot of information to work with.

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

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

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