3 ms·
There's no predicate or limit or inner join that could reduce the set of rows, so the table might as well be scanned.
by barrkel 8y ago
There's no predicate or limit or inner join that could reduce the set of rows, so the table might as well be scanned.
- deleted 8y ago[deleted]
- pytyper2 8y agoOr precompute the date on insert, there are a dozen ways to refactor the data model and the query, all of which are better than extracting to txt files, a format with no schema and not based on a standard. That would be the direction I would give if a junior dev was attempting this method.