defined indexes for Columns used a) in Joins b) in Search conditions..

Question

Please suggest how defined indexes for Columns used

 

a) in Joins

b) in Search conditions

c) Foreign key fields

d) Order by Clause?