G. Nau wrote:

>
> I use the following selects to search for a single record equal or
> greater than the searchstring:
> "select first(1) * from table where partnumber >= :search order by
> partnumber"
>
> It's working well, but kind of slow on bigger tables (>20.000 records).

What indexes do you have and what does the query plan look like?

Regards,


Ann