Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Spatial Insert Performance

Re: Spatial Insert Performance

From: Peter Sylvester <peters_no_spam_please_at_mitre.org>
Date: Mon, 12 Jul 2004 11:35:16 -0400
Message-ID: <ccub3l$mvh$1@newslocal.mitre.org>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US