Did you try SELECT COUNT(*) FROM trip ?<p>MySQL has optimizations for that, and since you’re counting the primary key column, which can’t contain NULL values, the result will be the same.<p>You might want to move the JSON column to a separate table with a 1:1 relationship (same primary key) to keep the row size down in the main table.