What is a SPATIAL INDEX and when should I use it?

Asked 2010-02-13T03:28:11.447

78

Like most of the average PHP web developers I use MySql as a RDBMS. MySql (as other RDBMS also) offers SPATIAL INDEX features, but I'm don't get it very well. I have googled for it but didn't find clear real world examples to clarify my bad knowledge about it.

Could someone explain me a little bit what is a SPATIAL INDEX and when should I use it?

mysql indexing spatial-index

Edit Report

1 Answer

36

You can use a spatial index for indexing geo-objects - shapes. The spatial index makes it possible to efficiently search for objects that overlap in space

answered 2010-02-13T03:37:10.487

What is a SPATIAL INDEX and when should I use it?

1 Answer

Your Answer