Slow query performance with DQL query using FTI attributes
Hello everyone, I have a DQL query that is running quite badly at the moment when it contains the FTI attributes score and summary as below: SELECT r_object_id, object_name, r_version_label, i_position, summary, score FROM dm_document WHERE ( object_name LIKE 'qwerty%' ESCAPE '\' ) ORDER BY object_name, r_object_id,…