Home » Server Options » Spatial » Least Effort Index (Window Server 2008, 11.1.0.7.0)
Least Effort Index [message #423227] Tue, 22 September 2009 20:57
db33
Messages: 21
Registered: July 2009
Junior Member
Hi,
I have a table with millions of points (lat/lon). Inserting into the table with an index on the point column drops by speed by 1/4.

All of my queries use other fields to break down the query to only a few rows, so I don't really use the index. However, I still want to use the SDO_WITHIN_DISTANCE function with a polygon, to remove a few rows from the result set.

So, what is my least intensive (least effort to build/update) index I can put on the point column so Oracle will still support spatial queries?

Thanks.
Previous Topic: Functions to return polygon data
Next Topic: OracleInProcServer Sdo_Geometry problem
Goto Forum:
  


Current Time: Thu Mar 28 15:48:28 CDT 2024