This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.
Remedy AR System Server
BMC Remedy AR System Server
Why do I have performance problems with Full Text Search (FTS)?
Legacy ID:KA330770A full text search is taking too long or returning insufficient data.
If your query involves more than one indexed field, it may not be constructed in the most efficient manner.
If the logic of the query permits, group the subclauses of your query. For example, assume your original query looked like this (and that only the Long-Description and Short-Description fields are FTS-indexed):
('Assigned Priority' = 3 AND 'Long-Description' LIKE "%network%") AND ('Short-Description' LIKE "%daemon%")
Reconstruct the query so that the actions against full text indexed fields are grouped. The above example could be rewritten as:
'Assigned Priority' = 3 AND ('Long-Description' LIKE "%network%" AND 'Short-Description' LIKE "%daemon%")