Home Forums SQL Server 7,2000 Performance Tuning OPENROWSET select statement performance -- runs in 4 seconds on test server vs. 3 minutes on production server. RE: OPENROWSET select statement performance -- runs in 4 seconds on test server vs. 3 minutes on production server.

  • August 30, 2008 at 4:11 pm

    #865413

    Does the Oracle table have the same number of rows in test and prod? Does the Oracle table in test and prod have the same indexes? When you use the linked servers, are both OLE DB or is one ODBC? And, why are you selecting against a whole Oracle table instead of an Oracle view that automatically limits the number of rows you want to return?

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)