SQL: Different types of join? SQL: What types or columns do you apply an index to?
Sigiloso
Primary Key is the first, unique and mandatory so a good choice Then any columns which appear often in query profiling are generally a good candidate as well.