3 ms·
The query includes `date_format(created_at, '%x%v1') as week_commit` - meaning it would need to be computed for every row.
by mutatio 8y ago
The query includes `date_format(created_at, '%x%v1') as week_commit` - meaning it would need to be computed for every row.
- mnw21cam 8y agoThat's only in the SELECT statement, which only needs to be performed after the join has been done.
- qoi2ijds0 8y agoOnly for every returned row. The projection does not affect the underlying result set, it merely "shapes" the results you have received. WHERE clauses are always run before SELECT
- VintageCool 8y agoThe query in the article has no WHERE clause. It must calculate that function for every row in `commits`.