2 ms·
I tend to find table aliases a step down in readability, and only use them as necessary, because now your eyes have to jump up and down to see where the columns
by Izkata 2y ago
I tend to find table aliases a step down in readability, and only use them as necessary, because now your eyes have to jump up and down to see where the columns come from.
- ausp 2y agoThe aliases don't force you to follow each one through; eyes can do no jumping if you like in either case. But if you can't infer from the column name which table they will come from, I find having the option to check far more preferable to that of having no way of knowing.
- rbanffy 2y agoI think the aliases in the example are very intuitive - it's easy to correctly guess where they come from.
- Suppafly 2y ago>I tend to find table aliases a step down in readability I suppose it depends on your database, one of the ones I work with all the time has crazy long table and view names and aliases make resulting SQL more readable.