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?For Example : select aB.col1,Ab.col2 from table1 AB join table2 CD on AB.col1 = cd.col1Question: 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. Read More