Setting up proper Indexes for my tables

Question

Good Day All,

I have an MS Access front end connected to an SQL back end. When I create tables I want to properly index these tables so that my queries will run more efficiently. Can someone point me to either web sites or recommend and books on the best practices and rules for indexing tables?

Thanks

Answer 1

I can't point out books or tutorials but I do have a few guidelines of my own that I always follow:

1) Index all foreign keys, specially those that you use in JOINs

2) Index columns that you frequently use in searching -- i.e. those that frequently appear in the "WHERE" clause

3) Primary key is an index so usually there is no need to create an additional index on it

That's about it