| Subject | Re: [ib-support] Query execution time jumps when adding a condition to where clause |
|---|---|
| Author | Bob Murdoch |
| Post date | 2003-04-21T16:07:48Z |
At 4/21/2003 12:14 PM, you wrote:
See, I told you I was happy to have back !!
Bob M..
>instead try adding :Yes, that absolutely did the trick.
>
>AND ((XRDS644_BUSINESS_DATE <= '03/10/2003' OR (0<>0))
>
>
>
>This will trick the optimizer into not using the index on that column
>(which in this
>particular case is better to ignore)).
See, I told you I was happy to have back !!
Bob M..