A full text index contains location information about each significant word in a string field of a table.
Some queries can use this information to run more efficiently and complete much sooner.
These are queries that search for words that are embedded in the middle of string fields
A regular index on a long string field can help a query complete quickly only if the query
searches for the word that is at the start of the string field.
In X++ SQL this is done with the like keyword and the * wildcard character, such as in the code phrase like "*van*".
Some queries can use this information to run more efficiently and complete much sooner.
These are queries that search for words that are embedded in the middle of string fields
A regular index on a long string field can help a query complete quickly only if the query
searches for the word that is at the start of the string field.
In X++ SQL this is done with the like keyword and the * wildcard character, such as in the code phrase like "*van*".
No comments:
Post a Comment