View Single Post

   
  #4 (permalink)  
Old 02-26-2008, 06:18 AM
sybrandb@hccnet.nl
 
Posts: n/a
Default Re: Differences between Oracle,DB2,SQL2005 in cost estimation

On 21 Apr 2007 01:19:30 -0700, Steven <songxin328@gmail.com> 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...
>=========
>Anyway, 3x for your reply~


Don Tov wrote a book on sql tuning published by O'Reilly discussing
Oracle, DB2 and sqlserver.
Please do not top post.

--

Reply With Quote