Do you remember that really long session that Ben gave over SQL Server during the class...that would be the section I would refer you back to in regards to answering this question.Generally we will never add an indexes haphazardly and only add them when we see a performance issue. Just adding an index on all of these fields would probably not be a good idea as they may just produce overhead or even slow things down. Dealing with dates especially if you are going to have some between operations may be a good place for an index...but this really depends on the database size, performance that you are experiencing, etc. So I can't give you a "Yes" or "No" answer here....it is more of a trial and error when dealing with performance issues.