Does performance get enhanced if smaller to bigger tables are joined in SQL?

Question

I have heard people saying, join small table to big table instead of other way to enhance the performance. Is it true?

Answer 1

No, It's not true.