Post reply

is OPENQUERY the best method???

  • May 30, 2002 at 9:36 am

    #64526

    Is the use of OPENQUERY the best method to select data from Oracle to SQL 2000 via a linkedserver.

    This would be incorporated in a SP that runs as part of a nightly batch cycle.

    TIA,

    Matt

  • May 30, 2002 at 10:09 am

    #430030

    I have found that using the open query syntax has better performance than using 4 part name.

    Hope that helps.

    Tom Goltl

  • May 30, 2002 at 10:31 am

    #430036

    OPENQUERY also has the bennifit of the fact the code inside is executed on the remote server and you can do a lot of manipulation that way to return the fewest needed records as possible, thus keeping network free of unneeded traffic.

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

  • May 30, 2002 at 11:11 am

    #430045

    Thanks... that's a big help.

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

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