I
inungh
I have a table which has millions records.
I understand that I need put WHERE clause which are index fields to
limit records and improve performance.
I would like to know does Access really bring the records only to
front end application depends on the WHERE clause or bring millions
records to front end application and doing analyze at front end
application?
If yes, it should help perfromance the stack queries like one query
use another query as source if previous query to limit recrods.
your information and help is great appreciated,
I understand that I need put WHERE clause which are index fields to
limit records and improve performance.
I would like to know does Access really bring the records only to
front end application depends on the WHERE clause or bring millions
records to front end application and doing analyze at front end
application?
If yes, it should help perfromance the stack queries like one query
use another query as source if previous query to limit recrods.
your information and help is great appreciated,