| Subject | Re: [ib-support] One line of WHERE clause slows query down |
|---|---|
| Author | Stevio |
| Post date | 2002-06-07T16:15:16Z |
You guys all win a prize :-) !!!
I removed the index and the query now takes less than 1 second.
4.51pm - post message about a slow query
5.10pm - query is now fast
The internet rocks (says an internet user of 8 years now :-)
Stephen
I removed the index and the query now takes less than 1 second.
4.51pm - post message about a slow query
5.10pm - query is now fast
The internet rocks (says an internet user of 8 years now :-)
Stephen
> Yeah the field is indexed. So removing it would help?
>
> I'll try that.
> Thanks,
> Stephen