Issuing a SELECT COUNT(*) will currently bump the number of rows read linearly to the number of rows. COUNT() results can be rather easily cached however (esp. without any WHERE clause), and then we could offer constant time COUNT () support which only reads a single row.
psarna
commented
1 year ago
Issuing a
SELECT COUNT(*)will currently bump the number of rows read linearly to the number of rows. COUNT() results can be rather easily cached however (esp. without any WHERE clause), and then we could offer constant time COUNT () support which only reads a single row.