This content has been marked as final. Show 3 replies
Now this is interesting. Originally I was going to say that you need to maintain the quality of your spatial index yourself, but when I looked up the documentation for 11R2 I found a note that [url http://docs.oracle.com/cd/E11882_01/appdev.112/e11830/sdo_objtune.htm#CACHEDCG]SDO_TUNE.QUALITY_DEGRADATION has been deprecated because
Thatmust be new in 11R2 I suppose? I always used to set up a Job to keep an eye on the index for frequently changing tables, but that seems not to be needed anymore. So your answer is: No, you don't :-)
You should not use this function. It is not needed because Spatial indexes are self-tuning.
You learn something new every day :-)