1 Reply Latest reply: Oct 10, 2012 8:12 PM by FlyingGuy RSS

    Inconstient Index Usage

      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 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.
        • 1. Re: Inconstient Index Usage
          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.