“where” clause not executed until entire database is pulled across net

[tbrauch]

I have an ODBC connection from NT Server to an Oracle database. When I execute a MS SQL query against that Oracle database, it appears that the “where” clause is not being executed until the entire database has been pulled over to the server ??? Any way to avoid this ?

Thanks

 

[MichaelRed]

tbrauch,

Stored procedure?

MichaelRed

 

[tbrauch]

I am in SQL Server query analyzer executing query batch.

 

[foxdev]

I've seen this with remote views from client-side database apps like Visual FoxPro, but never in the Query Analyzer.

In addition to MichaelRed's suggestion of creating and calling a stored procedure rather than executing the statement directly, you might also be able to create a view that includes the filter, then simply query the view.