I have heard over and over that you should add indexes to any foreign key you will be doing joins on.I have also heard you should have indexes for fields you will do queries on.Does anyone have a fair
Hypothetically, tets say someone tells you to to expect X (like 100,000 or something) number of unique visitors per day as a result of a successful marketing campaing.