This is an old revision of the document!


DRAFT

Omnidex SQL: CREATE INDEX

Description

Syntax

<code SQL>

  CREATE <OMNIDEX | QUICKTEXT | FULLTEXT | CUSTOM | NATIVE> INDEX [[(owner)]table.]index
      [ON table] (<column | substring> [, <column | substring>…] )]
      [KEYWORDING]
      [PROXIMITY]
      [<CASE_INSENSITIVE | CASE_SENSITIVE>]
      [STANDALONE]
      [BITMAP]
      [EXCLUDED_WORDS]
      [PHONETIC]
      [PREJOIN table]
      [<RECORD_SPECIFIC | RECORD_COMPLEX>]]
      IN “filename”
      [WITH options]

<code>

Discussion

arg1
arg2

Examples

Simple

CREATE OMNIDEX INDEX “households”.“hs” on “

2nd example

 
Back to top
dev/sql/statements/create_index/home.1273530370.txt.gz · Last modified: 2016/06/28 22:38 (external edit)