> select ways_tags.way_id, tag_keys.key, tags.value > from ways_tags > join tags on ways_tags.tag_id = tags.tag_id > join tag_keys on tags.key_id = tag_keys.key_id > where ways_tags.way_id in ( > select way_nodes.way_id > from way_nodes > join nodes on way_nodes.node_id = nodes.node_id > where nodes.latitude between 49.00 and 49.22 > and nodes.longitude between 14.88 and 15.10 )
Hi David, I've tried this select. Execution time is approximately 6 times longer...I've noticed somewhere that using JOIN and IN together doesn't work well. Maybe this is the case. But thanks for this idea. Martin -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
