This is an old revision of the document!
Omnidex supports a variety of options that can be applied to indexes. Not every option can be used with every index type, so the tables below show the options and when they can be used.
This table shows the options that are available for each index type. Note that Custom Indexes can use all options, and so these indexes should be used to achieve specific combinations that are not allowed in the other types.
Omnidex | QuickText | FullText | Custom | |
KEYWORDING | - | Implied | Implied | |
---|---|---|---|---|
CASE_SENSITIVE | Default | |||
CASE_INSENSITIVE | Default | Default | ||
PROXIMITY | - | - | Implied | |
PHONETIC | - | - | - | |
EXCLUDED_WORDS | - | Implied | Implied | |
BITMAP | - | - | - | |
STANDALONE | - | - | - | |
RECORD_SPECIFIC | - | - | - | |
RECORD_COMPLEX | - | - | - | |
PREJOIN table | - | - | - | |
————————————- | ————- | ————- | ————- | ————- |
This table shows the compatibility of index options with each other. Some index options are mutually exclusive, and some options imply other options. In the table below, combinations that are marked with “Implied” mean that the option to the left implies the option on the top.
KW | CS | CI | PX | PH | EW | BM | SA | RS | RC | PJ | ||
KEYWORDING | KW | - | Implied | Implied | - | - | ||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
CASE_SENSITIVE | CS | - | - | |||||||||
CASE_INSENSITIVE | CI | - | - | |||||||||
PROXIMITY | PX | Implied | Implied | - | Implied | - | - | - | - | - | ||
PHONETIC | PH | - | - | |||||||||
EXCLUDED_WORDS | EW | |||||||||||
BITMAP | BM | - | - | - | - | Implied | - | - | - | |||
STANDALONE | SA | - | - | - | - | - | - | - | ||||
RECORD_SPECIFIC | RS | - | - | - | - | - | ||||||
RECORD_COMPLEX | RC | - | - | - | - | - | ||||||
PREJOIN table | PJ | - | - | - | ||||||||
————————————- | ———- | ———- | ———- | ———- | ———- | ———- | ———- | ———- | ———- | ———- | ———- | ———- |
The KEYWORDING option causes the contents of the index to be parsed into keywords based on spaces and punctuation marks. The individual keywords are index and can be qualify separately in queries. For example, if a column containing “John Q. Doe” is indexed with KEYWORDING, it can be qualified using any of the following criteria:
See also: