It could be just a question for a micro-performance, but it always keeps coming back to my head (just making me crazy). I can't find any answer in Google about it. I just want to clarify it.
I have these two example queries.
SELECT tbl_person.first_name, tbl_person.last_name, .... FROM tbl_person WHERE tbl_person.tbl_person_id=1 LIMIT 1
and this one.
SELECT p.first_name, p.last_name, .... FROM tbl_person p WHERE p.tbl_person_id=1 LIMIT 1
Is there any advantage or disadvantage between them?
I know the second one is easier to read and write, but it doesn't matter because the query will be just generated.
I am interested in performance impact. If the query has a few hundred times more characters, does it hurt performance?