As part of Optimizing the queries in HIve, what should be the order of table size in a join query?

As part of Optimizing the queries in HIve, what should be the order of

1.	As part of Optimizing the queries in HIve, what should be the order of table size in a join query?
Answer» In a join query the smallest table to be taken in the first position and largest table should be taken in the last position.