Indexes in table join
I have three tables and I am using a join condition to link the three tables. Just need to know how can I improve the performance of the select query by using indexes. Can a secondary index be used in join table where in the where clause i have attributes from three different tables. If yes how do I do it.
Please suggest solution with examples.
Help will be much appreciated.