COUNT(*)
, with 16M records it takes 20 seconds when using local disk I/OSELECT zoom_level, tile_row, tile_column FROM tiles WHERE zoom_level = 1
SELECT tile_data FROM tiles WHERE zoom_level = 10 AND tile_row = 600 AND tile_column = 600
SELECT COUNT(*) FROM tiles WHERE zoom_level < 10