Path: utzoo!utgpu!news-server.csri.toronto.edu!mailrus!cs.utexas.edu!uunet!zephyr.ens.tek.com!tektronix!nosun!ohsuhcx!sjm
From: sjm@ohsuhcx.ohsu.edu (Sandra McMaster)
Newsgroups: comp.databases
Subject: Re: Oracle vs. Sybase on Sun 4:  That much difference!?
Message-ID: <404@ohsuhcx.ohsu.edu>
Date: 20 Mar 90 16:44:50 GMT
References: <1990Mar14.205620.11636@lia> <106035@pyramid.pyramid.com>
Reply-To: sjm@ohsuhcx.UUCP (Sandra McMaster)
Distribution: na
Organization: Oregon Health Sciences University, Portland
Lines: 19

In article <106035@pyramid.pyramid.com> eric@pyramid.pyramid.com (Eric Bergan) writes:
>In article <1990Mar14.205620.11636@lia> thomas@lia.UUCP (Chris Thomas) writes:
>>In Sybase, this completes in anywhere from
>>3 to 7 minutes (depending on other load), but Oracle seems to take
>>several -hours- to do the same thing.
>
>	Almost certainly, Sybase and Oracle are picking different
>query execution plans for the join. 

There is an EXPLAIN facility (mostly undocumented, I believe) in
Oracle V6 which will allow you to determine how the query is being
executed.  I have a paper which explains the EXPLAIN facility.  Let
me know if you are interested... I'll check with the author and see
if I can duplicate it.

Sandra McMaster
Oregon Health Sciences University
sjm@ohsu.edu
{nosun, tektronix, ogicse, qiclab}!ohsuhcx!sjm