After upgrading to SQL 2008 R2 on a new 64 bit server, linked queries are running 3 to 4 times as long. On the old 32 bit SQL 2005 system using MSDAORA, the below query takes 7 seconds. On the new 64 bit SQL 2008 R2 system using OraOLEDB.Oracle, it takes 23 seconds.
All of the searches I've done and articles I've read so far, suggest that this slow down is normal. Considering I just upgraded everything and everything else on the server is 2 to 3 times faster, this bothers me. Does anyone here have a solution or idea on how to deal with this?
FROM OPENQUERY(TEST,'Select ku_id, TOT_DATE from SIIY where TOT_DATE > 12252012')