This discussion is archived
3 Replies Latest reply: Jan 29, 2013 12:02 AM by 987510 RSS

Using Q-tree index or not?!

987510 Newbie
Currently Being Moderated
I would like to ask for advice!
Our directorate manages an Oracle Spatial database. We have about 2 millions of polygon geometries in a table.
In version 9.2 database we used Q-tree index, because the table was under heavy insert/update activity. But in newer versions of spatial databases the use of quadtree indexes is discouraged!
Does anyone have any experience in R-tree index in such kind of circumstances?

Thanks for advance!


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