получается?
:) select count(1) from distributed_transactions FINAL PREWHERE (record_datetime >= '2020-03-04 00:00:00') AND (record_datetime <= '2020-03-04 23:59:59')
SELECT count(1)
FROM distributed_transactions
FINAL
PREWHERE (record_datetime >= '2020-03-04 00:00:00') AND (record_datetime <= '2020-03-04 23:59:59')
┌─count(1)─┐
│ 15010398 │
└──────────┘
1 rows in set. Elapsed: 3.632 sec. Processed 16.69 million rows, 550.82 MB (4.60 million rows/s., 151.67 MB/s.)
:) select count(1) from distributed_transactions WHERE (record_datetime >= '2020-03-04 00:00:00') AND (record_datetime <= '2020-03-04 23:59:59')
SELECT count(1)
FROM distributed_transactions
WHERE (record_datetime >= '2020-03-04 00:00:00') AND (record_datetime <= '2020-03-04 23:59:59')
┌─count(1)─┐
│ 16691571 │
└──────────┘
1 rows in set. Elapsed: 0.038 sec. Processed 16.69 million rows, 66.77 MB (438.20 million rows/s., 1.75 GB/s.)
Потому что у WHERE не используется FINAL?
Обсуждают сегодня