Index by workload, not by table. ...
Build indexes based on predicates.
Index most-heavily used queries. ...
Index important queries. ...
Index to avoid sorting (GROUP BY, ORDER BY) ...
Create indexes for uniqueness (PK, U) ...
Create indexes for foreign keys. ...
Consider adding columns for...