openquery WHERE clause syntax
Posted on 2003-11-04
Am attempting to download data from an oracle linked server. Data is from a view not a physical table. Using Openquery works but having problem with timeouts. Is there another more efficient way to download a lot of data?
OS-> Win2k DB-> SQL Server RemoteDb-> Oracle 9
SELECT * INTO L_Tic1 FROM OPENQUERY(ORADB, 'SELECT * FROM S_TIC1 ') WHERE TICKET_NUMBER LIKE N'2003%' and CENTER = N'ABC'
This is taking to long.... Would their be any performance savings if the where clause was embedded within the openquery? Attempts to test the differences have been thwarted b/c the column name is not recognized even though different naming qualifications were attempted. What naming convention would work.. mind you that this is a view and no access to the original physical tables is available. Have the schema name but no catalog name or user table owner for the oracle db.