Pulled from Frank Booth's mail (Fri, Mar 14, 2003 at 02:44:07PM +0000): > On Fri, Mar 14, 2003 at 01:31:29PM +0000, Simon wrote: > > On Fri, 2003-03-14 at 10:02, Dominic Mitchell wrote: > > > Aaron Trevena wrote: > > > > I mean in college I used UNIX and SQL, but in the first year at university > > > > we used rubbish like Access (later we obviously used Oracle and decent > > > > databases). > > > > > > Oracle? Decent Database? That's a whole other thread. ;-) > > > > Compared to Ingress which almost put me off databases for life when in > > uni? :) > > Which has a far more powerful optimizer than Oracle or Sybase and is the > origins of Postgres, which can use Perl for it's stored procedures IIRC. > > An Oracle query will perform with varying degrees of efficiency, > recognising useful indexes etc, based entirely on the sequence of the > query, not good.
This has not necessarily been the case since the cost-based optimizer was introduced with Oracle7; this bases its execution plan on (previously derived) analyses of the structures involved. -- Alex Hooper