Home Forums SQL Server 2008 Working with Oracle Execution plan difference when executed from Oracle VS SSMS RE: Execution plan difference when executed from Oracle VS SSMS

  • January 20, 2014 at 2:18 pm

    #1681673

    PaulB-TheOneAndOnly (1/20/2014)

    Ville-Pekka Vahteala (1/16/2014)

    Hi.

    We are having performance problems on our server. We have found out that execution plans (attached) are very different when query is executed from SSMS and Oracle.

    Does anyone has had similar cases? Did you were able to fix it?

    Any particular reason to use SSMS to connect to Oracle?

    I could have written that more clearly. Query is executed from procedure in Oracle. So actually Oracle is connecting to sql server.

    I had to use index hint to get execution plan work for our needs.