15.1 SEM_APIS.ADD_DATATYPE_INDEX
Format
SEM_APIS.ADD_DATATYPE_INDEX( datatype IN VARCHAR2, tablespace_name IN VARCHAR2 DEFAULT NULL, parallel IN PLS_INTEGER DEFAULT NULL, online IN BOOLEAN DEFAULT FALSE, options IN VARCHAR2 DEFAULT NULL, network_owner IN VARCHAR2 DEFAULT NULL, network_name IN VARCHAR2 DEFAULT NULL);
Description
Adds a data type index for the specified data type to an RDF network.
Parameters
- datatype
-
URI of the data type to index.
- tablespace_name
-
Destination tablespace for the index.
- parallel
-
Degree of parallelism to use when building the index.
- online
-
TRUE
allows DML operations affecting the index during creation of the index;FALSE
(the default) does not allow DML operations affecting the index during creation of the index. - options
-
String specifying options for index creation using the form OPTION_NAME=option_value. Supported options associated with spatial index creation are
SRID
,TOLERANCE
, andDIMENSIONS
. For materialized spatial index creation, useMATERIALIZE=T
. Supported options associated with text index creation arePREFIX_INDEX
,PREFIX_MIN_LENGTH
,PREFIX_MAX_LENGTH
,SUBSTRING_INDEX
andLOGGING
. For function-based numeric ordateTime
index creation, useFUNCTION=T
. The option name keywords are case sensitive and must be specified in uppercase. - network_owner
-
Owner of the RDF network. (See Table 1-2.)
- network_name
-
Name of the RDF network. (See Table 1-2.)
Usage Notes
You must have DBA privileges to call this procedure.
For more information about data type indexing, see Using Data Type Indexes.
For information about creating a like index, see the lightweight text search material in Full-Text Search.
For information about creating a data type index on RDF spatial data, see Indexing Spatial Data.
For information about RDF network types and options, see RDF Networks.
Examples
The following example creates an index on xsd:string
typed literals and plain literals in the MY_TBS tablespace.
EXECUTE SEM_APIS.ADD_DATATYPE_INDEX('http://www.w3.org/2001/XMLSchema#string', tablespace_name=>'MY_TBS', parallel=>4);
Parent topic: SEM_APIS Package Subprograms