Text indexes are built according to the settings defined for the text configuration object used to create the text index. A term does not appear in a text index if any of the following conditions are true:
If you search for a term that is not in the text index, the term is dropped before the query is processed. The exact way
that it is dropped depends on where the term is specified. For example, suppose in the following that the term
'the' is in the stoplist:
'the AND apple',
'the OR apple', or
'the NEAR apple'are equivalent to searching for
'apple AND NOT the'is equivalent to searching for
If the term appears on the left side of an AND NOT, it is not dropped and, consequently, no rows are returned.
'feed the dog'matches
'feed the dog',
'feed my dog',
'feed any dog', and so on.
If none of the terms you are searching for are in the text index, no rows are returned. For example, suppose both
'a' are in the stoplist. Searching for
'a OR the' returns no rows.
|Send feedback about this page via email or DocCommentXchange||Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0|