Question SQL Pass-Through Query Advice

[purceld2]

I have a Make-Table Query via an ODBC connection to some Oracle tables. It returns 12500 records but takes approx 10 mins to run. I have been advised to convert it to an SQL Pass-Through Query which I am told will improve the performance.

1, How do I covert to SQL Pass-Through Query

2, Will it improve performance.

Thanks you in advance

Des

 

[Marty_Bailey]

Microsoft KB article 303968 explains it step by step. http://support.microsoft.com/kb/303968