Re: Differences between Oracle,DB2,SQL2005 in cost estimation

Steven wrote:
> Yeah, actually, I mean the cost based optimization.
> I think in general they were based on System-R model in calculating
> the execuation cost.
> that is: Total cost = i/o cost + cpu cost
>
> but Is there anything different when to implement this formula?
> I read this article below
> Cost Control: Inside the Oracle Optimizer
> and I am looking for similar articles about other dbms...
> =========

I am not aware of person or persons that have done the hard work of Oracle experts such as Jonathan Lewis and Julian Dyke with either DB2 or SQL Server.

In SQL Server, likely, the tools to do so don't even exist in the product.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org