An alias is a logical pointer to an alternate table name. The purpose of an alias is to resolve loops in the paths of joins. In some cases, more than one alias may be necessary for a given table.
Actually, What happens in the back end (i.e) in database end, while alias is performed, whether it points to one table or too many table. How the performance will be in universe level.
Please help me by explaining with this concept correctly, because i faced such question by interviewer.
