我在一个(x double, y double, z double)表中有大约100亿行坐标为MySQL的点。我已经在x、y和z列上创建了索引索引,这样按范围进行筛选就很好了。explain select id from points_table where x between 1-5 and 1+5 and y between 5-5 and 5+5 and z between -6-------+-------+---------+------+--------+----------------------------