For example like
CREATE INDEX bar_si ON foo(geometry)
INDEXTYPE IS MDSYS.SPATIAL_INDEX
PARAMETERS ('layer_gtype=POINT')
Thanks,
Yola
Question
Oracle Writer Spatial Index Parameters
+1- Participant
I'm using FME Desktop 2013 and writing to a new table with the Oracle SpatialWriter . Is there any way to use the parameters clause for the spatial index creation statement? I'd like to specify a layer_gtype for my spatial indexes.
+21- Contributor
Are you able to make use of the Advanced Parameter that can run after the translation, found on the writer? Instead of using the dedicated indexing parameters...
+17- Contributor
I never use the SQL parameters in FME to create the Spatial index on an Oracle table.
To control what you need to do I would create the Metadata before and the Spatial index after inserting the data into the table using SQL scripts or statements in a SQL application (SQLDeveloper, SQL*Plus or Toad). If you need to reload a big table, dropping the Spatial index before inserting and recreating it after inserting the data will boost your performance.
Creating the Metadata before inserting will allow you to add a SRID to the geometry as FME reads the Metadata to define the SRID.
Reply
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.