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. Names of tables, views, indexes, and aliases that are 30 characters or less will generally perform much better names longer than 30 characters.

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 minimal performance impact when the statement is executed. Otherwise, the conversion is done at execution time and has a small performance impact.