SQL Performance - CA PPM - Using Table Aliases

Using Table Aliases

Improves readability of SQL

Use meaningful table aliases

SELECT A.ID FROM SRM_RESOURCES
JOIN ODF_CA_RESOURCE B ON A.ID=B.ID


Allows queries to be modified more easily

SELECT ID FROM SRM_RESOURCES
JOIN ODF_CA_RESOURCE ON SRM_RESOURCES.ID =ODF_CA_RESOURCE .ID


Help performance by eliminating the need for the datbase to search the tables for the referenced column