Subject | Re: 1=1 in where gets a bad performance |
---|---|
Author | kokok_kokok |
Post date | 2008-11-14T20:52:19Z |
Yes, BeginParity has an index, and it does matter if I change the
order of statements. When I add 1=1, seems that Firebird evaluated all
rows, I thought that the optimizer wpuld delete the 1=1 expression,
but maybe it is the expected behavior.
Thanks
order of statements. When I add 1=1, seems that Firebird evaluated all
rows, I thought that the optimizer wpuld delete the 1=1 expression,
but maybe it is the expected behavior.
Thanks