Subject Re: [ib-support] Slow Search
Author Sandeep
On 22 Nov 2001, at 9:15, Jason Wharton wrote:

> Unless you show us the prepare of the statement associated with the handle,
> and thus its plan as well, there probably isn't anything we can suggest that
> you would have control over.

The problem is that the IndexName property for the table is set to
an Index which is descending, but when the table is opened the
query which it makes up has ascending order by clause. To get
around this I'm calling unprepare and prepare. This fixes the
problem as it puts descending in order by clause for those fields



Software Developer