Ok here is the search that first brought this issue to my attention: mysql spatial index example lft rgt I see the following order: 1: http://planet.mysql.co

Ok here is the search that first brought this issue to my attention: mysql spatial index example lft rgt I see the following order: 1: http://planet.mysql.com/entry/?id=23512 http://planet.mysql.com/entry/?id=23512 2: http://efreedom.com/Question/1-1743894/Mysql-Optimizing-Finding-Super-Node-Nested-Set-Tree http://efreedom.com/Question/1-1743894/Mysql-Optimizing-Find... 3: http://explainextended.com/2009/09/29/adjacency-list-vs-nested-sets-mysql/ http://explainextended.com/2009/09/29/adjacency-list-vs-nest... 4: http://stackoverflow.com/questions/1743894/mysql-optimizing-finding-super-node-in-nested-set-tree http://stackoverflow.com/questions/1743894/mysql-optimizing-...