Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Spatial Insert Performance
I actually started looking at setting up quadtree indexes for
comparison, but hit ORA-600s at every turn.
Guess I should patch up to 9.2.0.4 or 9.2.0.5 and give it another try...
thanks,
--Peter
Jan wrote:
> If you read "Oracle Spatial User's Guide and Reference"
>
> there in a caption:
>
> "Indexing of Spatial Data"
>
> is a table "Choosing R-tree or Quadtree Indexing"
>
> http://download-west.oracle.com/docs/cd/B10501_01/appdev.920/a96630/sdo_intro.htm#sthref91
>
> where is written:
>
> "If there is heavy update activity to the
> spatial column, an R-tree index may not
> be a good choice.
> Heavy update activity does not affect the
> performance of a quadtree index."
>
> BTW, I found on metalink there is a list of bugs in 9.2.0.3 fixed in
> 9.2.0.4 related to SDO, maybe better to work with last patched version
> although the bugs are not related to inserts.
>
> Jan
>
>
Received on Mon Jul 12 2004 - 10:35:16 CDT