Home » Microsoft » MB6-704 » What should you do on Table l?
You have a table named Table l that contains a string field named Description.
Users want to search for records in Table l based on words that might be present in Description.
The words can be anywhere in the Description field.
You need to ensure that when the users create queries that are filtered based on the Description field, the query results must be returned in the least amount of time possible.
What should you do on Table l?
A. Create a non-unique index in Description.
B. Add Description to the AutoSummary field group.
C. Create a full text index in Description.
D. Write a find method.
Correct Answer: C
Explanation/Reference:
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 "*diamond*".
Reference: Full Text Index Overview [AX 2012]