This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
admin:indexing:indexes:options [2012/01/30 20:39] doc |
admin:indexing:indexes:options [2012/04/04 15:45] doc |
||
---|---|---|---|
Line 23: | Line 23: | ||
|< 60% 40% 15% 15% 15% 15% >| | |< 60% 40% 15% 15% 15% 15% >| | ||
| | **Omnidex** | **QuickText** | **FullText** | **Custom** | | | | **Omnidex** | **QuickText** | **FullText** | **Custom** | | ||
- | |**[[#keywording|KEYWORDING]]** ^ --- | Implied | Implied | Allowed | | + | |**[[#keywording|KEYWORDING]]** ^ --- | Implied | Implied | OK | |
- | |**[[#case_sensitive|CASE_SENSITIVE]]** | Default | Allowed | Allowed | Allowed | | + | |**[[#case_sensitive|CASE_SENSITIVE]]** | Implied | OK | OK | OK | |
- | |**[[#case_insensitive|CASE_INSENSITIVE]]** | Allowed | Default | Default | Allowed | | + | |**[[#case_insensitive|CASE_INSENSITIVE]]** ^ --- | Default | Default | OK | |
- | |**[[#proximity|PROXIMITY]]** Allowed ^ --- ^ --- | Implied | Allowed | | + | |**[[#proximity|PROXIMITY]]** ^ --- ^ --- | Implied | OK | |
- | |**[[#phonetic|PHONETIC]]** Allowed ^ --- ^ --- ^ --- | Allowed | | + | |**[[#phonetic|PHONETIC]]** ^ --- | OK | OK | OK | |
- | |**[[#excluded_words|EXCLUDED_WORDS]]** ^ --- | Implied | Implied | Allowed | | + | |**[[#excluded_words|EXCLUDED_WORDS]]** ^ --- | Implied | Implied | OK | |
- | |**[[#bitmap|BITMAP]]** Allowed | Allowed ^ --- ^ --- | Allowed | | + | |**[[#bitmap|BITMAP]]** | OK ^ --- ^ --- | OK | |
- | |**[[#standalone|STANDALONE]]** Allowed ^ --- ^ --- ^ --- | Allowed | | + | |**[[#standalone|STANDALONE]]** | OK ^ --- ^ --- | OK | |
- | |**[[#record_specific|RECORD_SPECIFIC]]** ^ --- ^ --- ^ --- | Allowed | | + | |**[[#record_specific|RECORD_SPECIFIC]]** ^ --- ^ --- ^ --- | OK | |
- | |**[[#record_complex|RECORD_COMPLEX]]** ^ --- ^ --- ^ --- | Allowed | | + | |**[[#record_complex|RECORD_COMPLEX]]** ^ --- ^ --- ^ --- | OK | |
- | |**[[#prejoin_table|PREJOIN table]]** ^ --- ^ --- ^ --- | Allowed | | + | |**[[#prejoin_table|PREJOIN table]]** ^ --- ^ --- ^ --- | OK | |
=== Index Option Compatibility === | === Index Option Compatibility === | ||
Line 42: | Line 42: | ||
|< 100% 18% 5% 7% 7% 7% 7% 7% 7% 7% 7% 7% 7% 7% >| | |< 100% 18% 5% 7% 7% 7% 7% 7% 7% 7% 7% 7% 7% 7% >| | ||
| | | **KW** | **CS** | **CI** | **PX** | **PH** | **EW** | **BM** | **SA** | **RS** | **RC** | **PJ** | | | | | **KW** | **CS** | **CI** | **PX** | **PH** | **EW** | **BM** | **SA** | **RS** | **RC** | **PJ** | | ||
- | |**[[#keywording|KEYWORDING]]** | **KW** ^ --- | Allowed | Implied | Allowed | Allowed | Implied ^ --- ^ --- | Allowed | Allowed | Allowed | | + | |**[[#keywording|KEYWORDING]]** | **KW** ^ --- | OK | Implied | OK | OK | Implied ^ --- ^ --- | OK | OK | OK | |
- | |**[[#case_sensitive|CASE_SENSITIVE]]** | **CS** | Allowed ^ --- ^ --- | Allowed | Allowed | Allowed | Allowed | Allowed | Allowed | Allowed | Allowed | | + | |**[[#case_sensitive|CASE_SENSITIVE]]** | **CS** | OK ^ --- ^ --- | OK | OK | OK | OK | OK | OK | OK | OK | |
- | |**[[#case_insensitive|CASE_INSENSITIVE]]**| **CI** | Allowed ^ --- ^ --- | Allowed | Allowed | Allowed | Allowed | Allowed | Allowed | Allowed | Allowed | | + | |**[[#case_insensitive|CASE_INSENSITIVE]]**| **CI** | OK ^ --- ^ --- | OK | OK | OK | OK | OK | OK | OK | OK | |
- | |**[[#proximity|PROXIMITY]]** | **PX** | Implied | Allowed | Implied ^ --- | Allowed | Implied ^ --- ^ --- ^ --- ^ --- ^ --- | | + | |**[[#proximity|PROXIMITY]]** | **PX** | Implied | OK | Implied ^ --- | OK | Implied ^ --- ^ --- ^ --- ^ --- ^ --- | |
- | |**[[#phonetic|PHONETIC]]** | **PH** | Allowed | Allowed | Allowed | Allowed ^ --- | Allowed ^ --- | Allowed | Allowed | Allowed | Allowed | | + | |**[[#phonetic|PHONETIC]]** | **PH** | OK | OK | OK | OK ^ --- | OK ^ --- | OK | OK | OK | OK | |
- | |**[[#excluded_words|EXCLUDED_WORDS]]** | **EW** | Allowed | Allowed | Allowed | Allowed | Allowed ^ --- | Allowed | Allowed | Allowed | Allowed | Allowed | | + | |**[[#excluded_words|EXCLUDED_WORDS]]** | **EW** | OK | OK | OK | OK | OK ^ --- | OK | OK | OK | OK | OK | |
- | |**[[#bitmap|BITMAP]]** | **BM** ^ --- | Allowed | Allowed ^ --- ^ --- | Allowed ^ --- | Implied ^ --- ^ --- ^ --- | | + | |**[[#bitmap|BITMAP]]** | **BM** ^ --- | OK | OK ^ --- ^ --- | OK ^ --- | Implied ^ --- ^ --- ^ --- | |
- | |**[[#standalone|STANDALONE]]** | **SA** ^ --- | Allowed | Allowed ^ --- | Allowed ^ --- | Allowed ^ --- ^ --- ^ --- ^ --- | | + | |**[[#standalone|STANDALONE]]** | **SA** ^ --- | OK | OK ^ --- | OK ^ --- | OK ^ --- ^ --- ^ --- ^ --- | |
- | |**[[#record_specific|RECORD_SPECIFIC]]** | **RS** | Allowed | Allowed | Allowed ^ --- | Allowed | Allowed ^ --- ^ --- ^ --- ^ --- | Allowed | | + | |**[[#record_specific|RECORD_SPECIFIC]]** | **RS** | OK | OK | OK ^ --- | OK | OK ^ --- ^ --- ^ --- ^ --- | OK | |
- | |**[[#record_complex|RECORD_COMPLEX]]** | **RC** | Allowed | Allowed | Allowed ^ --- | Allowed | Allowed ^ --- ^ --- ^ --- ^ --- | Allowed | | + | |**[[#record_complex|RECORD_COMPLEX]]** | **RC** | OK | OK | OK ^ --- | OK | OK ^ --- ^ --- ^ --- ^ --- | OK | |
- | |**[[#prejoin_table|PREJOIN table]]** | **PJ** | Allowed | Allowed | Allowed ^ --- | Allowed | Allowed ^ --- ^ --- | Allowed | Allowed ^ --- | | + | |**[[#prejoin_table|PREJOIN table]]** | **PJ** | OK | OK | OK ^ --- | OK | OK ^ --- ^ --- | OK | OK ^ --- | |
=== Option Descriptions === | === Option Descriptions === | ||
Line 80: | Line 80: | ||
== PROXIMITY == | == PROXIMITY == | ||
- | The PROXIMITY option is similar to the KEYWORDING option; however, it also records the relative location of the keywords within the index. This allows the use of extended operators that compare the location of one keyword against another, such as the NEAR, BEFORE, and AFTER operators. The PROXIMITY option also enables the use of the $CONTEXT and $SCORE functions in the SQL Engine. Consult the article on [[admin:features:text|Omnidex Text]] for more information on these operators and functions. | + | The PROXIMITY option is similar to the KEYWORDING option; however, it also records the relative location of the keywords within the index. This allows the use of extended operators that compare the location of one keyword against another, such as the NEAR, BEFORE, and AFTER operators. The PROXIMITY option also enables the use of the $CONTEXT and $SCORE functions in the SQL Engine. Consult the article on [[admin:indexing:text:home|Omnidex Text]] for more information on these operators and functions. |
The PROXIMITY option implies the KEYWORDING option, and unless overridden, implies the CASE_INSENSITIVE and EXCLUDED_WORDS options. | The PROXIMITY option implies the KEYWORDING option, and unless overridden, implies the CASE_INSENSITIVE and EXCLUDED_WORDS options. | ||
Line 86: | Line 86: | ||
== PHONETIC == | == PHONETIC == | ||
- | The PHONETIC option causes the contents of the index to include the phonetic equivalent of the data, as well as the original data itself. The PHONETIC option is required to use the PHONETIC option in a $CONTAINS function. Consult the article on [[admin:features:text|Omnidex Text]] for more information on these operators and functions. | + | The PHONETIC option causes the contents of the index to include the phonetic equivalent of the data, as well as the original data itself. The PHONETIC option is required to use the PHONETIC option in a $CONTAINS function. Consult the article on [[admin:indexing:text:home|Omnidex Text]] for more information on these operators and functions. |
== EXCLUDED_WORDS == | == EXCLUDED_WORDS == | ||
Line 106: | Line 106: | ||
== RECORD_SPECIFIC == | == RECORD_SPECIFIC == | ||
- | The RECORD_SPECIFIC option is used in conjunction with the PREJOIN option to create a pre-joined index. The RECORD_SPECIFIC option indicates that the index in the pre-joined child table should record information about both the row and the parent. This provides a powerful ability to join between multiple children in a parent. At the same time, these indexes are more expensive to build and are slower in base qualifications. Consult the article on [[admin:indexing:advanced:prejoin|Prejoined Indexes]] for more information about this option. | + | The RECORD_SPECIFIC option is used in conjunction with the PREJOIN option to create a pre-joined index. The RECORD_SPECIFIC option indicates that the index in the pre-joined child table should record information about both the row and the parent. This provides a powerful ability to join between multiple children in a parent. At the same time, these indexes are more expensive to build and are slower in base qualifications. |
The RECORD_SPECIFIC and RECORD_COMPLEX options are mutually exclusive. | The RECORD_SPECIFIC and RECORD_COMPLEX options are mutually exclusive. | ||
Line 112: | Line 112: | ||
== RECORD_COMPLEX == | == RECORD_COMPLEX == | ||
- | The RECORD_COMPLEX option is used in conjunction with the PREJOIN option to create a pre-joined index. The RECORD_COMPLEX option indicates that the index in the pre-joined child table should record information about only the parent. This is valuable when a single column in a pre-joined child is used as criteria. This provides a powerful ability to join between a child and its parent. Consult the article on [[admin:indexing:advanced:prejoin|Prejoined Indexes]] for more information about this option. | + | The RECORD_COMPLEX option is used in conjunction with the PREJOIN option to create a pre-joined index. The RECORD_COMPLEX option indicates that the index in the pre-joined child table should record information about only the parent. This is valuable when a single column in a pre-joined child is used as criteria. This provides a powerful ability to join between a child and its parent. |
The RECORD_SPECIFIC and RECORD_COMPLEX options are mutually exclusive. | The RECORD_SPECIFIC and RECORD_COMPLEX options are mutually exclusive. | ||
Line 118: | Line 118: | ||
== PREJOIN table == | == PREJOIN table == | ||
- | The PREJOIN option is used to pre-join a RECORD_SPECIFIC or RECORD_COMPLEX index with a parent table. This is required for Prejoined Indexes. Consult the article on [[admin:indexing:advanced:prejoin|Prejoined Indexes]] for more information about this option. | + | The PREJOIN option is used to pre-join a RECORD_SPECIFIC or RECORD_COMPLEX index with a parent table. This is required for Prejoined Indexes. |
==== ==== | ==== ==== |