Path: utzoo!mnetor!tmsoft!torsqnt!lethe!yunexus!ists!helios.physics.utoronto.ca!news-server.csri.toronto.edu!cs.utexas.edu!wuarchive!sdd.hp.com!elroy.jpl.nasa.gov!decwrl!fernwood!oracle!news
From: jklein@.com (Jonathan Klein)
Newsgroups: comp.databases
Subject: Re: how bad is oracle?
Message-ID: <1991Feb7.064930.12572@oracle.com>
Date: 7 Feb 91 06:49:30 GMT
References: <10737@pasteur.Berkeley.EDU> <1991Feb3.182558.14411@oracle.com> <9292@cognos.UUCP>
Reply-To: jklein@oracle.UUCP (Jonathan Klein)
Organization: Oracle Corporation, Belmont, CA
Lines: 32

In article <9292@cognos.UUCP> nigelc@cognos.UUCP (Nigel Campbell) writes:
>In article <1991Feb3.182558.14411@oracle.com> jklein@oracle.UUCP (Jonathan Klein) writes:
>>In article <10737@pasteur.Berkeley.EDU> mao@eden.Berkeley.EDU (Mike Olson) writes:
>>>a couple of days ago i posted a query about oracle to this newsgroup.
>>>since i got no response, i thought i would repost with a more provocative
>>>subject line.
>>>
>>>here's the question:  i have heard that oracle does not have a query
>>>optimizer.  i find this surprising.  is it true?
>>>
>
>[stuff deleted]
>
>>All versions of oracle that I have worked with have had an query optimizer.
>>
>>Jonathan Klein
>
>Would you like to give a comparison on the merits of the Oracle approach
>vs say Rdb/Vms,Interbase,Sybase etc especially based on a database where
>the user has not taken to using physical row,table placement schemes . 
>
>
Query optimization is not my area of development; I was just posting a
response to correct some misinformation about whether oracle does perform
any optimization processing. 
>
>
>-- 
>Nigel Campbell          Voice: (613) 783-6828                P.O. Box 9707
>Cognos Incorporated       FAX: (613) 738-0002                3755 Riverside Dr.
>uucp: nigelc@cognos.uucp || uunet!mitel!cunews!cognos!nigelc Ottawa, Ontario
>|| nigelc@cognos.uucp.@ccs.carleton.ca                       CANADA  K1G 3Z4