Subject Locate & Indexes
Author Tom Deprez

I'm a little lost here. I've a TIBOQuery on a table (15795 records). The table itself as a primary key of 'POSTCODE_ID;STREETNAME'.
When I perform a Locate as in:


It seems to be very slow. I've to use this query each time when I want to insert a record in another table.
Does TIBOQuery uses the keys defined on the table automatically (since then locate works the fastest) or do I've to define it somewhere.

Is there a better way to do this then using locate? Stored Procedure? How would this procedure than look like?

Thanks in advance,

[Non-text portions of this message have been removed]