Re: Distributed Join

In article <james.lawrence.45.0012036C@EPAMAIL.EPA.GOV> james.lawrence@EPAMAIL.EPA.GOV writes: >Both oracle and ingres have done a much better job of making it possible to >have multi-database joins that are transparent. Oracle has been doing >it for about as long as ingres. However anyone considering this for >production systems should be aware that nobody is optimizing distributed joins >yet. Unfortunately this means that there is no value in making it transparent >, since it wouldn't perform worth a shit. Nonsense. Ingres/Star optimizes distributed queries so as to minimise the amount of data that has to be sent between nodes. Additionally metrics can be defined for the relative speeds of comms links so that the optimizer can allow for any nodes that are on the end of slow lines. Regards, -- ------------------------------------------------------------------------------- Bruce Horrocks "Audiences are sometimes needed Hampshire, England for acoustical purposes." Arnold Schoenburg bh@granby.demon.co.uk -------------------------------------------------------------------------------