Path: utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!sdd.hp.com!spool.mu.edu!uunet!comp.vuw.ac.nz!matai.vuw.ac.nz!ctl.co.nz!mcintoshc
From: mcintoshc@ctl.co.nz
Newsgroups: comp.databases
Subject: Re: how bad is oracle?
Message-ID: <1991Feb7.142156.13433@ctl.co.nz>
Date: 7 Feb 91 01:39:41 GMT
References: <10737@pasteur.Berkeley.EDU> <1991Feb3.182558.14411@oracle.com> <9292@cognos.UUCP> <1991Feb6.144339.10316@lgc.com>
Organization: Computertime Ltd.
Lines: 28

> 
> Oracle's syntactically-based optimizer approach permits fine-tuning of the 
> SQL statement for added performance. This advantage, however, is generally 
> lost during ad hoc querying by less sophisticated users since fine-tuning 
> requires a good understanding of the database structure and an appreciation 
> for Oracle's optimizer strategies. The rumor mill has it that Oracle is 
> preparing a statistically-based optimizer. I would not be surprise if this 
> optimizer comes to be regarded as the most effective in the industry.
> ---
> Ernest Rubi			Phone : (713) 579-4789

May I summarize -  If you get the query statement right, Oracle can optimize
it, if you get it wrong (by that I mean in the syntactically correct, "wrong"
order) that Oracle cannot optimise :-(

Another well-known database product has an intelligent optimiser which is 
_already_ regarded as the most effective in the Industry :-)
   - OK you guessed - INGRES.

-----------------------------------------------------------------------------
From :   Colin McIntosh,  Project Manager      	 #        .=====. ======== 
     	 Computertime Ltd,  P.O. Box 6243	 #       /     /     /    /
	 Wellington, New Zealand		 #      /           /    /
Phone:   (04) 852 195				 #     /           /    /
Fax  :   (04) 828 288				 #    /     /     /    /
Internet:    MCINTOSHC@NZFC.CO.NZ  		 #    ======     /     ======
Disclaimer:  My speak is my speak not their speak ...
-----------------------------------------------------------------------------