Database Tuning (MOSC)

MOSC Banner

APPEND_VALUES hint ignored for table with spatial index column

edited Oct 9, 2018 5:00AM in Database Tuning (MOSC) 8 commentsAnswered

Hi,

OS = OEL5, database = 11.2.0.4

It looks like the APPEND_VALUES direct path insert hint is ignored on tables with a spatially indexed column. Test case as follows...

CREATE TABLE SpatialTest_table

   (ID          INTEGER,

    Location    MDSys.SDO_Geometry)

   STORAGE (INITIAL      1M

            PCTINCREASE  0

            NEXT         1M);

         

------------------------------------------------------------

-- Set up Spatial metadata for indexing of Location...

------------------------------------------------------------

INSERT INTO User_SDO_Geom_Metadata

       (TABLE_NAME,

        COLUMN_NAME,

        DIMINFO,

        SRID)

     VALUES

     (

     'SPATIALTEST_TABLE',

     'Location',

      SDO_DIM_ARRAY

      (

        SDO_DIM_ELEMENT('Longitude',-180,180,1),

        SDO_DIM_ELEMENT('Latitude',  -90, 90,1)

      ),8307);

   

      commit;

CREATE INDEX SPATIALTEST_TABLE_SI1

   ON SPATIALTEST_TABLE(Location)

   INDEXTYPE IS MDSYS.SPATIAL_INDEX

   PARAMETERS

    ('Layer_gType=POINT Tablespace=USERS SDO_Non_Leaf_Tbl=TRUE SDO_RTr_PctFree=0 Initial=1K PctIncrease=0 Next=1K');

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center