Improve Performance of Query by using table Prefixes & Table Alias

https://plsqlquery.blogspot.com/2018/05/improve-performance-of-query-by-using.html


Using table Prefixes

select EMP.EMPNO,
EMP.ENAME,
EMP.JOB,
EMP.DEPTNO,
DEPT.DNAME,
DEPT.LOC
from EMP, DEPT
where EMP.DEPTNO = DEPT.DEPTNO;


Using Table Alias

select a.EMPNO,
a.ENAME,
a.JOB,
a.DEPTNO,
b.DNAME,
b.LOC
from EMP a, DEPT b
where a.DEPTNO = b.DEPTNO;