Re: Cost mystery

From: Ana C. Dent <anacedent_at_hotmail.com>
Date: Thu, 15 Feb 2007 03:05:55 GMT
Message-ID: <n6QAh.25867$D03.16545@newsfe13.phx>

"astalavista" <nobody_at_nowhere.com> wrote in news:45d36bee$0$15939$426a74cc_at_news.free.fr:

> Hi,
>
> Oracle 9.2.0.6
>
> I have a query wich take 2 min to execute with a cost = 8529,
> the 2nd query (equivalent) take more than 1 hour with a cost = 12
>
> How do you explain that ?
>

Cost values can ONLY be compared when the SQL produces the same result set. Otherwise you are trying to compare apples to oranges. Received on Wed Feb 14 2007 - 21:05:55 CST