我有一个网格表,其中包含经度、经度、城市名称、地区以及从城市到地区的距离。我想找出用户到最近城市的距离。select r.id, r.lat, r.long, r.city, r.dist from select q.id, q.lat, q.long, q.city, q.dist, rank() over (partition by q.lat, q.long order by q.dist) as seq from select ul.id, ul.lat::numeric,
我有个疑问:SELECT i.ipStart, i.ipEnd, i.descr JOIN visit_count v WHERE v.last_visit BETWEEN '2014-10-10' AND '2014-10-22' 随着时间的延长,上面的速度是非常慢的。上面的时间大约是20秒。`visit_count` (
`id` int