Home > database >  SQL server link to oracle use OpenQuery instead more slowly
SQL server link to oracle use OpenQuery instead more slowly

Time:03-06

Before the SQL server use DBLINK query oracle
Select * from MES... ZMES. TBLINVINTRANSACTION A time WHERE XXX s
Using the new method
Select * from OPENQUERY (MES, 'select * from ZMES. TBLINVINTRANSACTION WHERE A... ') 62 s

Use the openquery should be faster, isn't it, why instead of a times slower
  • Related