Improve the performance of an Query.

Question

When we select data from multiple tables millions of records. how to improve the execution process?

 

My Answer: 1)Don't Use * when we use select statement, instead of * use the required columns.

 2) Add an index to the columns.

3) avoid the union