Index or sort

S

Scott

When I construct a database for multi-users on file server, should I use
index or sort to give the best performance.

Thanks,

Scott
 
T

Tom Wickerath

Hi Scott,

I can't say that I really understand your question...however, you should
consider indexing fields that you use to specify criteria or sort orders in
queries. Check out this document, especially the sections on Indexing and
using JET Show Plan:

Implementing a Successful Multiuser Access/JET Application
http://www.access.qbuilt.com/html/multiuser_applications.html


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________
 
Top