I am doing some anyinteract queries and I am noticing that the spatial index utilization is very inconsitent. For some queries, the spatial index gets used as expected and for other queries I have to use an index hint to force the optimizer to use the spatial index instead of doing a full table scan. Oracle version is 126.96.36.199. I was wondering if anyone else has been seeing this kind of behavior. I did see one bug in metalink that referenced this issue but they were no updates provided.
Yes this is a problem. I have tables that have geom's in them, fully indexed and do a spacial query and return a numeric ID and no hint required, but add the geom to the return set and suddenly right to a table scan. This is troubling behavior.