1 Reply Latest reply: Feb 7, 2013 10:39 AM by John O'Toole RSS

    Spatial Index Fragmentation

    Gokul Gopal
      Hello,

      We are facing a problem with spatial query performance on 10.2.0.5.

      Apologies for limited information, I am still gathering information, but thought of asking this upfront.

      What we have noticed is that queries involving SDO_ANYINTERACT runs slower say at about 8 secs. On Export/Import of data, the same query
      runs in 0.5 secs.

      Has anyone had a similar issue ? From the spatial index table I am not able identify if there is any fragmentation.

      Pls let me know.

      Rgds,
      Gokul
        • 1. Re: Spatial Index Fragmentation
          John O'Toole
          Gokul,

          You'll have to provide a lot more information to get a meaningful answer.

          I haven't found any issues with spatial queries on 10.2.0.5.
          - Can you supply us your SQL query, preferably with an execution plan?
          - How many rows in the table?
          - How many rows does the query return?
          - Is the data in a projected coordinate system or not?
          - What do you mean by Export/Import and what is different about the query run at that stage?

          John