Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: query optimization in different databases?

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@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 Fri Oct 03 2003 - 20:55:51 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US