top of page
CerebroSQL

Oracle:

ALTER INDEXTYPE

ALTER INDEXTYPE [ schema. ] indextype
{ { ADD | DROP } [ schema. ] operator ( parameter_types )
[ , { ADD | DROP } [schema. ] operator ( parameter_types ) ]... [ using_type_clause ]
| COMPILE
}
[ WITH LOCAL [ RANGE ] PARTITION ] [ storage_table_clause ]
;

example

ALTER INDEXTYPE position_indextype COMPILE;

bottom of page