>If I have a table that has 5 fields that if combined create a "primary key", is it faster to use LOCATE to find a record, or SEEK.
>
>The 5 fields are not all characters fields (one is date and one is numeric).
>
>Regards
In any case you would obtain an expression that locate could benefit the index. It'd somehow need an overhead time to optimize search. IMHO seek is faster.
Cetin