Support Article
FTSIndexer Queue table degrades application performance
SA-41911
Summary
FTSIndexer Queue table degrades application performance.
Error Messages
Not Applicable
Steps to Reproduce
Unknown
Root Cause
Application performance degrades due to numerous rule updates or rule inserts in to the table over a period of time.
Resolution
Perform the below local-change:
Execute the following command to defragment the table,
sppr_defragment_table(tablename,schemaname)
Published October 9, 2017 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.