At 12:21 PM 11/5/01 +0300, Dmitry Kuzmenko wrote:

>
>Anyway, I have a test case when 2 databases with the same data
>gives different plans. If I change bad plan at DB 1 to the good plan
>from DB2, query time will be same and the best.
>So, we have case when optimizer incorrectly uses cost estimation.
>

No, it only demonstrates that there is a bug. The way to find
a bug is to go into the code and find out why it's getting the
wrong answer.

Jim Starkey