Query times

[FRED_EMMERICH_(Guest)]

I have an Access table with about 100k records. I am trying to query about 100 records or so from that table. It takes a LONG time, even doing multiple previews. If instead I create a different master table which contains the identifiers from the big table, and link on that field, the query time is MUCH quicker. Why is it so much faster to use the link method than the filter? It would seem like it would need to check all the records in the big table no matter which way I go, but I may be wrong.____Thanks

[kfleming]

Could be in how the ODBC driver processes the SELECT. I am assuming that in the first case your SELECT contains a WHERE clause with the filtering condition.____Kathleen__R&R Support

[FRED_EMMERICH_(Guest)]

In my slow case (single table) I used the filter to select the records. In the faster one where I linked, I used all records, but only retrieved the ones from the large table that matched my master file records.