Re: Oracle: Naked King in database land?

From: Mikito Harakiri <mikharakiri_at_ywho.com>
Date: Tue, 1 Apr 2003 17:59:48 -0800
Message-ID: <hAria.15$Pt1.19@news.oracle.com>

"Anne" <anne_at_thereistoomuchspam.com> wrote in message news:9oqia.9952$Pp.1241589_at_amsnews03.chello.com...
> * query optimizer clearly less intelligent than MS-Access and MySQL on
some
> cases. Never found to be more intelligent.(Oracle workaround: analyze
tables
> compute statistics, forcing use of indexes by removing wrongly used ones,
> forcing change of query execution plan by using nested queries).

I certainly agree that oracle micro management is quite annoying for a person who don't want to be a master of segments, extents and other silly quirks. You are, however, not quite right trying to match MS-Access and MySQL optimizers with Oracle. For one thing, MySQL discovered subqueries only recently -- why do you expect that their optimizer might do anything intelligent with them? I'm not certain if MS-Access even has subqueries. It would be very surprising to find anything but very rudimentary query optimization in those, very basic "databases".

If you are talking about optimizer, the right comparison would be DB2 and SQLServer.

In general, if you look into query optimization, you'll find problems in every RDBMS. This is not necessarily because of the bugs. This is because the problem is well known to be hard. Received on Tue Apr 01 2003 - 19:59:48 CST