Creating an Index

Pre-8.1

In pre-8.1, you create an index using CTX_DDL.CREATE_INDEX and name a policy.

8.1

In 8.1, you create the Text index as a type of extensible index using the CREATE INDEX SQL command. You name the index and optionally specify the preferences such as lexer and filter in the parameter string.

See Also: To learn more about the CREATE INDEX command syntax, see the Oracle8i interMedia Text Reference.

Create Index Example

The following example creates a Text index called newsindex on the news column in mytable. The index is created with the lexer preference called my_lexer and the stoplist called my_stop. Default attributes are used for the unspecified preferences.

create index newsindex on mytable(news) indextype is ctxsys.context 
  parameters('lexer my_lexer stoplist my_stop');