This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
admin:indexing:text:proximity [2012/01/31 19:48] doc |
admin:indexing:text:proximity [2016/06/28 22:38] (current) |
||
|---|---|---|---|
| Line 10: | Line 10: | ||
| [[admin:indexing:text:retrieve|External Files]] | | [[admin:indexing:text:retrieve|External Files]] | | ||
| **[[admin:indexing:text:proximity|Proximity Searches]]** | | **[[admin:indexing:text:proximity|Proximity Searches]]** | | ||
| + | [[admin:indexing:text:advanced|Advanced Searches]] | | ||
| [[admin:indexing:text:results|Displaying Results]] | | [[admin:indexing:text:results|Displaying Results]] | | ||
| [[admin:indexing:text:relevancy|Relevancy]] | [[admin:indexing:text:relevancy|Relevancy]] | ||
| Line 23: | Line 24: | ||
| There are three basic categories of Proximity Searches: | There are three basic categories of Proximity Searches: | ||
| - | == Phrase Searches == | + | === Phrase Searches === |
| A phrase search finds occurrences of between two and eight words adjacent to each other in the column. To specify phrases in the search criteria, enclose the phrase in double quotation marks. The following example searches for the phrase "No place like home" in the sample BOOKS database, finding the Wizard of Oz. | A phrase search finds occurrences of between two and eight words adjacent to each other in the column. To specify phrases in the search criteria, enclose the phrase in double quotation marks. The following example searches for the phrase "No place like home" in the sample BOOKS database, finding the Wizard of Oz. | ||
| Line 36: | Line 37: | ||
| - | == BEFORE Searches == | + | === BEFORE Searches === |
| A BEFORE search is an expansion on a Phrase Search. The BEFORE operator used in qualification criteria allows more control over how many words are allowed between two keywords. In fact, a Phrase Search is simply a special implementation of a BEFORE search. | A BEFORE search is an expansion on a Phrase Search. The BEFORE operator used in qualification criteria allows more control over how many words are allowed between two keywords. In fact, a Phrase Search is simply a special implementation of a BEFORE search. | ||
| Line 55: | Line 56: | ||
| This example immediate raises the question of how to see the locations in the book where this criteria is met, and also how to sort the results based on relevancy. The [[admin:indexing:text:results|next two pages]] of this section describe functions that can be used to meet these requirements. | This example immediate raises the question of how to see the locations in the book where this criteria is met, and also how to sort the results based on relevancy. The [[admin:indexing:text:results|next two pages]] of this section describe functions that can be used to meet these requirements. | ||
| - | == NEAR Searches == | + | === NEAR Searches === |
| A NEAR search is nearly the same as a BEFORE search, except that the words can be in any relative order to each other. The NEAR operator is used between two words, as in "word1 NEAR(n) word2". The NEAR operator accepts an optional parameter containing a value between 1 and 999, representing the number of words by which //word1// may precede or follow //word2//. If no value is provided, the default value of 10 is used. | A NEAR search is nearly the same as a BEFORE search, except that the words can be in any relative order to each other. The NEAR operator is used between two words, as in "word1 NEAR(n) word2". The NEAR operator accepts an optional parameter containing a value between 1 and 999, representing the number of words by which //word1// may precede or follow //word2//. If no value is provided, the default value of 10 is used. | ||
| Line 71: | Line 72: | ||
| </code> | </code> | ||
| - | == Default Proximity Search == | + | === Default Proximity Search === |
| Any search against a FullText index is inherently a Proximity Search. Specifically, the NEAR(999) operator is used whenever there is no other operator before words. This means that the following two examples are synonymous: | Any search against a FullText index is inherently a Proximity Search. Specifically, the NEAR(999) operator is used whenever there is no other operator before words. This means that the following two examples are synonymous: | ||
| Line 98: | Line 99: | ||
| </code> | </code> | ||
| - | ===== ===== | + | === Proximity Search Limitations === |
| There are some limitations to Proximity Searches. Columns indexed with the Proximity option are limited to 4 million keywords. The Proximity option cannot be used on pre-joined indexes. Lastly, Proximity Searches only pay attention to word proximity, and not to semantics, sentence structure or context. | There are some limitations to Proximity Searches. Columns indexed with the Proximity option are limited to 4 million keywords. The Proximity option cannot be used on pre-joined indexes. Lastly, Proximity Searches only pay attention to word proximity, and not to semantics, sentence structure or context. | ||
| + | ===== ===== | ||
| **[[admin:indexing:text:retrieve|Prev]]** | | **[[admin:indexing:text:retrieve|Prev]]** | | ||
| - | **[[admin:indexing:text:results|Next]]** | + | **[[admin:indexing:text:advanced|Next]]** |
| ====== Additional Resources ====== | ====== Additional Resources ====== | ||