MB6-704 · Question #59
You have a table named Tablel that contains a string field named Description. Users want to search for records in Tablel based on words that might be present in Description. The words can be…
The correct answer is C. Create a full text index in Description. 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…
Question
You have a table named Tablel that contains a string field named Description. Users want to search for records in Tablel 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 Tablel?
Options
- ACreate a non-unique index in Description.
- BAdd Description to the Auto Summary field group.
- CCreate a full text index in Description.
- DWrite a find method.
How the community answered
(38 responses)- A8% (3)
- B5% (2)
- C74% (28)
- D13% (5)
Explanation
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".
Topics
Community Discussion
No community discussion yet for this question.