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 [2011/03/15 19:51] 127.0.0.1 external edit |
admin:indexing:indexes:options [2016/06/28 22:38] (current) |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| ~~NOTOC~~ | ~~NOTOC~~ | ||
| + | |||
| {{page>:top_add&nofooter&noeditbtn}} | {{page>:top_add&nofooter&noeditbtn}} | ||
| Line 19: | Line 20: | ||
| 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. In the table below, combinations that are shaded and contain a dash are disallowed. | 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. In the table below, combinations that are shaded and contain a dash are disallowed. | ||
| + | |||
| + | |< 60% 40% 15% 15% 15% 15% >| | ||
| | | **Omnidex** | **QuickText** | **FullText** | **Custom** | | | | **Omnidex** | **QuickText** | **FullText** | **Custom** | | ||
| - | |**[[#keywording|KEYWORDING]]** ^ - | Implied | Implied | | | + | |**[[#keywording|KEYWORDING]]** ^ --- | Implied | Implied | OK | |
| - | |**[[#case_sensitive|CASE_SENSITIVE]]** | Default | | | | | + | |**[[#case_sensitive|CASE_SENSITIVE]]** | Implied | OK | OK | OK | |
| - | |**[[#case_insensitive|CASE_INSENSITIVE]]** | | Default | Default | | | + | |**[[#case_insensitive|CASE_INSENSITIVE]]** ^ --- | Default | Default | OK | |
| - | |**[[#proximity|PROXIMITY]]** ^ - ^ - | Implied | | | + | |**[[#proximity|PROXIMITY]]** ^ --- ^ --- | Implied | OK | |
| - | |**[[#phonetic|PHONETIC]]** ^ - ^ - ^ - | | | + | |**[[#phonetic|PHONETIC]]** ^ --- | OK | OK | OK | |
| - | |**[[#excluded_words|EXCLUDED_WORDS]]** ^ - | Implied | Implied | | | + | |**[[#excluded_words|EXCLUDED_WORDS]]** ^ --- | Implied | Implied | OK | |
| - | |**[[#bitmap|BITMAP]]** | ^ - ^ - | | | + | |**[[#bitmap|BITMAP]]** | OK ^ --- ^ --- | OK | |
| - | |**[[#standalone|STANDALONE]]** ^ - ^ - ^ - | | | + | |**[[#standalone|STANDALONE]]** | OK ^ --- ^ --- | OK | |
| - | |**[[#record_specific|RECORD_SPECIFIC]]** ^ - ^ - ^ - | | | + | |**[[#record_specific|RECORD_SPECIFIC]]** ^ --- ^ --- ^ --- | OK | |
| - | |**[[#record_complex|RECORD_COMPLEX]]** ^ - ^ - ^ - | | | + | |**[[#record_complex|RECORD_COMPLEX]]** ^ --- ^ --- ^ --- | OK | |
| - | |**[[#prejoin_table|PREJOIN table]]** ^ - ^ - ^ - | | | + | |**[[#prejoin_table|PREJOIN table]]** ^ --- ^ --- ^ --- | OK | |
| - | |-------------------------------------|-------------|-------------|-------------|-------------| | + | |
| === Index Option Compatibility === | === Index Option Compatibility === | ||
| Line 37: | Line 39: | ||
| 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. Combinations that are shaded and contain a dash are disallowed. | 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. Combinations that are shaded and contain a dash are disallowed. | ||
| + | |||
| + | |< 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** ^ - | | Implied | | | Implied ^ - ^ - | | | | | + | |**[[#keywording|KEYWORDING]]** | **KW** ^ --- | OK | Implied | OK | OK | Implied ^ --- ^ --- | OK | OK | OK | |
| - | |**[[#case_sensitive|CASE_SENSITIVE]]** | **CS** | ^ - ^ - | | | | | | | | | | + | |**[[#case_sensitive|CASE_SENSITIVE]]** | **CS** | OK ^ --- ^ --- | OK | OK | OK | OK | OK | OK | OK | OK | |
| - | |**[[#case_insensitive|CASE_INSENSITIVE]]**| **CI** | ^ - ^ - | | | | | | | | | | + | |**[[#case_insensitive|CASE_INSENSITIVE]]**| **CI** | OK ^ --- ^ --- | OK | OK | OK | OK | OK | OK | OK | OK | |
| - | |**[[#proximity|PROXIMITY]]** | **PX** | Implied | | Implied ^ - | | Implied ^ - ^ - ^ - ^ - ^ - | | + | |**[[#proximity|PROXIMITY]]** | **PX** | Implied | OK | Implied ^ --- | OK | Implied ^ --- ^ --- ^ --- ^ --- ^ --- | |
| - | |**[[#phonetic|PHONETIC]]** | **PH** | | | | ^ - | ^ - | | | | | | + | |**[[#phonetic|PHONETIC]]** | **PH** | OK | OK | OK | OK ^ --- | OK ^ --- | OK | OK | OK | OK | |
| - | |**[[#excluded_words|EXCLUDED_WORDS]]** | **EW** | | | | | ^ - | | | | | | | + | |**[[#excluded_words|EXCLUDED_WORDS]]** | **EW** | OK | OK | OK | OK | OK ^ --- | OK | OK | OK | OK | OK | |
| - | |**[[#bitmap|BITMAP]]** | **BM** ^ - | | ^ - ^ - | ^ - | Implied ^ - ^ - ^ - | | + | |**[[#bitmap|BITMAP]]** | **BM** ^ --- | OK | OK ^ --- ^ --- | OK ^ --- | Implied ^ --- ^ --- ^ --- | |
| - | |**[[#standalone|STANDALONE]]** | **SA** ^ - | | ^ - | ^ - | ^ - ^ - ^ - ^ - | | + | |**[[#standalone|STANDALONE]]** | **SA** ^ --- | OK | OK ^ --- | OK ^ --- | OK ^ --- ^ --- ^ --- ^ --- | |
| - | |**[[#record_specific|RECORD_SPECIFIC]]** | **RS** | | | ^ - | | ^ - ^ - ^ - ^ - | | | + | |**[[#record_specific|RECORD_SPECIFIC]]** | **RS** | OK | OK | OK ^ --- | OK | OK ^ --- ^ --- ^ --- ^ --- | OK | |
| - | |**[[#record_complex|RECORD_COMPLEX]]** | **RC** | | | ^ - | | ^ - ^ - ^ - ^ - | | | + | |**[[#record_complex|RECORD_COMPLEX]]** | **RC** | OK | OK | OK ^ --- | OK | OK ^ --- ^ --- ^ --- ^ --- | OK | |
| - | |**[[#prejoin_table|PREJOIN table]]** | **PJ** | | | ^ - | | ^ - ^ - | | ^ - | | + | |**[[#prejoin_table|PREJOIN table]]** | **PJ** | OK | OK | OK ^ --- | OK | OK ^ --- ^ --- | OK | OK ^ --- | |
| - | |-------------------------------------|----------|----------|----------|----------|----------|----------|----------|----------|----------|----------|----------|----------| | + | |
| === Option Descriptions === | === Option Descriptions === | ||
| Line 55: | Line 58: | ||
| == KEYWORDING == | == KEYWORDING == | ||
| - | 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: | + | The KEYWORDING option causes the contents of the index to be parsed into keywords based on spaces and punctuation marks. The individual keywords are indexed and can be qualified 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: |
| * "John" | * "John" | ||
| * "Doe" | * "Doe" | ||
| Line 77: | 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 83: | 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 103: | 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 109: | 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 115: | 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. |
| ==== ==== | ==== ==== | ||