Re: Distributed Join

In article <james.lawrence.45.0012036C@EPAMAIL.EPA.GOV> james.lawrence@EPAMAIL.EPA.GOV writes: > >Well actually, Sybase *can* ! The product to do this is OMNI and it supports > >distributed joins across most data sources (including, I think, some > >non relational ones). > 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. Well, I think that OMNI is about as transparent as you can get. Possibly INGRES and Oracle have been doing it for a long time, but that isn't really relevant to the best solution today. As to distributed optimisation, OMNI does optimise distributed joins (because unlike its competitors, it has a global dictionary). Rather than post an advert, if you are interested call your local Sybase office and ask for a copy of the OMNI technical paper. Best wishes, Eoin. -- Eoin Woods, Watford, Hertfordshire, WD1 1PD, UK Email: Eoin@copse.demon.co.uk