Re: Multi-Server Links

> I am from an Oracle shop (I know: hiss! boo!) and we have come across a > problem that we hope another DBMS like Informix can solve. > > We have multiple servers and are linking views together across the > servers. However, when views are joined in a query, Oracle cannot tell > if the views in the join are on the same server (and thus the join be > done on the home server) so it issues individual queries for each part > of the join, fetches the data to the server issuing the query and then > performs the join. > > Needless to say, the performance is abysmal. How does Informix do this? > If I understand your question correctly INFORMIX knows where tables, and I assume views, are on the network. If two views were on the same server INFORMIX would probably - depending on statistics and query - spawn the query to the remote machine. But you would need to test this! I can't as I've only got a single UNIX server configuration. > > Regards, > Ron Merner Phone: (604) 952-1248 > Systems, FAX: (604) 952-1289 > Ministry of Health Internet: rmerner@bcsc02.gov.bc.ca Malcolm Weallans Online Database Consultancy Phone 01628-72154 Fax 01628-37463 CIX - onlinedbc