2 ms·
I got descriptive table names like WhsTransactionGoodsItems and WhsTransactionGoodsItemPackages. I feel it would be rather noisy to have to specify such table
by magicalhippo 6y ago
I got descriptive table names like WhsTransactionGoodsItems and WhsTransactionGoodsItemPackages.
I feel it would be rather noisy to have to specify such table names in front of the 15+ column references in a query, compared to using aliases.
Then again I've never had to diff the result sets, so I guess our usage is quite different.
- mulmen 6y agoMy editor has tab completion, it's not like you have to type every character. I prefer it for readability but it's definitely debatable.
- magicalhippo 6y agoReadability is weird heh, I'm exactly the opposite. For me long lines become a blur, so better to have a short alias.
- mulmen 6y agoI know what you mean. I think this is really a matter of readability vs comprehension. I want all the context on one line so I can understand it, even if that does technically make it harder to read that line. This is especially a problem in huge queries.