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?
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.
Alright! Thx!