Effects on database performance when using long object names

Long object names are converted internally to system object names when used in SQL statements. This conversion can have some performance impacts. Start of changeNames of tables, views, indexes, and aliases that are 30 characters or less will generally perform much better than names longer than 30 characters.End of change

Qualify the long object name with a library name and the conversion to the short name happens at precompile time. In this case, there is Start of changeminimalEnd of change performance impact when the statement is executed. Otherwise, the conversion is done at execution time and has a small performance impact.