So, this is a newbie type issue as I'm quite certain there is a simple solution I just haven't found it yet. I'm an old Oracle DBA who is new to SQL Server so I'm currently struggling.
Anyway, I have created a linked server from my SQL Server database. I can easily issue distributed queries or I can use openquery without problems so the link is working. The OLEDB I am using is Microsoft's not Oracle's so it is possible that changing the version of the oledb may solve my problem.
The SQL statements I am issuing are simple but are not being executed as pass through queries. The documentation seems to indicate that it should work (do the processing on the Oracle side)ÃÂ but it doesn't. This is important as the source table in Oracle I am hitting is about 7 gig in size (fact table) and the performance sucks.
I can't use openquery because my SQL statement is dynamic. Openquery doesn't use variables it want's a constant so if I'm doing domething wrong there let me know. I can limit the result set to about 700,000 records with openquery but the other parameters are variables so I can't get to the small result setÃÂ I want which are onlyÃÂ a fewÃÂ dozen records at most.
Is there a way to issue dynamic pass through queries? Should I change oledb versions / products? Should I be using Execute? The documentation says that "SQL Server 2005 extends the EXECUTE statement so
View Complete Post