Why do I have performance problems with Full Text Search (FTS)?

Version 2
    Share:|

    This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.


    PRODUCT:

    Remedy AR System Server


    APPLIES TO:

    BMC Remedy AR System Server



    QUESTION:

    Why do I have performance problems with Full Text Search (FTS)?


    ANSWER:

     

    Legacy ID:KA330770

    A 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%") 

     


    Article Number:

    000021188


    Article Type:

    FAQ/Procedural



      Looking for additional information?    Search BMC Support  or  Browse Knowledge Articles