1 Reply Latest reply on Oct 11, 2012 1:12 AM by FlyingGuy

    Inconstient Index Usage

    user154136
      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 11.2.0.3. 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.