Walter Meester
HoogkarspelNetherlands
General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Mark,
Seek is faster than locate because it doesn't have the overhead of rushmore. The larger the table gets, the faster SEEK gets compared to locate.
Walter,
>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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only