Forum Discussion
Performance Tuning
The alias name used in the query can affect query performance?
For Example : select aB.col1,Ab.col2 from table1 AB join table2 CD on AB.col1 = cd.col1
Question: I have given alias name with capital letters but I used small and caps in the select and join conditions . does it affect?
when I seeing execution plan there is no diff.
Thank you.
The alias name used in the query can affect query performance?saravanakumar28 , absolutely not.
I always use alias, especially because it prevents "logical error" in queries.
- Thank you olafhelper
