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@x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org