Re: query optimization in different databases?
From: Bob Devine <bob.devine.NOSPAM_at_worldnet.att.net>
Date: Sat, 04 Oct 2003 01:55:51 GMT
Message-ID: <MPG.19e7d693424f439d98968c_at_127.0.0.1>
Date: Sat, 04 Oct 2003 01:55:51 GMT
Message-ID: <MPG.19e7d693424f439d98968c_at_127.0.0.1>
In article <blg64h$brq8p$1_at_ID-125932.news.uni-berlin.de>,
cbbrowne_at_acm.org says...
> I'm not sure what strategy Microsoft has taken when they rewrote
> Sybase's codebase, whether they are rule-based or cost-based. MySQL
> does rule-based optimization, pointing back to '80s technology.
It's basically a cost-based optimizer with some internal pattern-matching rules.
Bob Devine
(one of the folks who wrote it)
Received on Sat Oct 04 2003 - 03:55:51 CEST