This discussion is archived
1 Reply Latest reply: Feb 7, 2013 8:39 AM by John O'Toole RSS

Spatial Index Fragmentation

GokulGopal Newbie
Currently Being Moderated
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 Journeyer
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points