VERY bad. The sample code i posted retrieves just under half a million records and it takes almost 8 hours. Definitely bad compared to the less than 2...

Joe,

In my case, I have tested the select statement on it's own in Query Analyser and found insignificant change in performance (I put a sample of our code in a...

Thanks for the reply Jeff.

I only put the comment about TOAD as a comparison to what I was getting through linked servers in SQL Server. We have no joins,...

Jeff,

I'm also using linked server w/ INSERT/SELECT stored procedures to extract a couple of dozen Oracle tables to SQL Server overnight but I am getting horrible performance (~7hrs for half...