Hello, I have a spatial table with about 1 million rows (extracted from the italian ways shapefile).
I create a spatial index on that table. Then, I tried to perform the same query; the first time I have not used the index, the second one I tried to take full advantage from it. But, the execution time of the two queries is quite the same. Everybody knows why? Here the two queries: Without index: SELECT name FROM italia_900000 it, ( SELECT Transform(GeomFromText('POINT(7.662359 45.062477)', 4326), 32632) as the_geom_32632 ) as p WHERE Intersects(it.the_geom_32632, p.the_geom_32632); With index: SELECT name FROM italia_900000 it, ( SELECT Transform(GeomFromText('POINT(7.662359 45.062477)', 4326), 32632) as the_geom_32632 ) as p WHERE Intersects(it.the_geom_32632, p.the_geom_32632) AND it.pk_uid in ( SELECT pkid FROM idx_italia_900000_the_geom_32632 WHERE MBRMinX(p.the_geom_32632) - 100 < xmax and MBRMaxX(p.the_geom_32632) + 100 > xmin and MBRMinY(p.the_geom_32632) - 100 < ymax and MBRMaxY(p.the_geom_32632) + 100 > ymin ); -- View this message in context: http://old.nabble.com/Spatialite-RTree-index-tp31903692p31903692.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users