2 ms·
I agree with you in general but I avoid table names or aliases when the query uses only one table because that adds no clarity. Also, table names are often muc
by mulmen 9y ago
I agree with you in general but I avoid table names or aliases when the query uses only one table because that adds no clarity. Also, table names are often much longer than "user" so aliases can be useful. I do agree that aliases like a, b, c should be avoided and if an alias is required it should be descriptive.
On my team we have a lot of common table aliases which are used by convention. We understand what they mean and it gets the point across without using 20 characters.