Subject Re: [firebird-support] slow query at first execution
Author Helen Borrie
At 01:12 PM 28/04/2004 +0200, you wrote:

>no. it's more elaborated.
>the row is inserted.
>then, on demand, is retrieved using an alternate key (the primary key is
>not known by who make the request) to perform an update.
>in normal conditions this happens some seconds after the insert.
>sometimes, it happens some days later.
>i have an index on the alternate key (the key is made up by 2 fields, a
>varchar and an integer).

A UNIQUE index?

/hb