MySQL Forums
Forum List  »  GIS

Re: Why my query took so long
Posted by: Albert Rovira
Date: December 22, 2009 10:21AM

Because the query don't use RTREE indexs after all.

In order to improve this query you can add an new field with a LINE GEOMETRY. Create an RTREE index on this field. And query it with MBRCONTAINS() ... Remember that this function give false positives.

Options: ReplyQuote


Subject
Views
Written By
Posted
3730
December 09, 2009 11:58AM
Re: Why my query took so long
2150
December 22, 2009 10:21AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.