XPost: comp.databases.ms-sqlserver   
   From: srielau@ca.eye-bee-m.com   
      
   Daniel,   
      
   It seems the original poster is sitting on SQL Server. The Oracle DBMS   
   belongs to "another Group". So the argumnet of traing goes teh other way   
   around.   
   I don't know SQL Server well enough, but I'd be surprised if they don't   
   support OLE Table Functions which then, of course, allows T-SQL to hit   
   multiple sources at the same time, just like transparent gateway does.   
   The really interesting question is: How much optimization does   
   transparent gateway provide (in Oracle 8)? Only if it supports   
   distributed optimization with subquery pushdown to SQL Server will there   
   be any conceptual difference since OLE does not provide such   
   capabilities. Judging by the whitepapers available so far it seems some   
   of this heterogeneous optimization is coming in Oracle 10g, but that   
   isn't what the poster has.   
      
   Cheers   
   Serge   
   --   
   Serge Rielau   
   DB2 SQL Compiler Development   
   IBM Toronto Lab   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)