Skip to main content
Question

Spatial database indexes with fme


carolina_w
Contributor
Forum|alt.badge.img+11

Hi,

I have a question regarding the “create spatial index” option in the spatial database writer for Oracle.

If you’re truncating an spatial table with an existing index. Do you still need the create index option on or is it redundant? And if not, is there any performance loss in keeping it on?

2 replies

kailinatsafe
Safer
Forum|alt.badge.img+21

Hello @carolina_w​, thanks for posting! I think enabling the create spatial index option on the writer would really only be needed for the first/initial load of the data, or if you drop the table. If just truncating I think oracle would remove all data from the index and then re-create/populate it afterwards. You can likely set this parameter to 'NO'! Hope this helps, Kailin.


carolina_w
Contributor
Forum|alt.badge.img+11
  • Author
  • Contributor
  • July 26, 2023

Alright! Thx!


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings