Performance Tuning

[saravanakumar28]

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.

[#2]

---

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.

[#3]

Thank you @olafhelper