Path: utzoo!utgpu!cunews!cognos!nigelc From: nigelc@cognos.UUCP (Nigel Campbell) Newsgroups: comp.databases Subject: Re: how bad is oracle? Message-ID: <9292@cognos.UUCP> Date: 6 Feb 91 05:18:49 GMT References: <10737@pasteur.Berkeley.EDU> <1991Feb3.182558.14411@oracle.com> Reply-To: nigelc@cognos.UUCP (Nigel Campbell) Organization: Cognos Inc., Ottawa, Canada Lines: 28 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 . -- 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