Subject | Re: [IB-Architect] Firebird Query Speed improvement |
---|---|
Author | Jim Starkey |
Post date | 2001-11-05T14:45:06Z |
At 12:21 PM 11/5/01 +0300, Dmitry Kuzmenko wrote:
a bug is to go into the code and find out why it's getting the
wrong answer.
Jim Starkey
>No, it only demonstrates that there is a bug. The way to find
>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.
>
a bug is to go into the code and find out why it's getting the
wrong answer.
Jim Starkey