To clear/delete the search index tables manually. Follow the steps below:
- Login as 'HOST' (Super user account)
- In Host Menu select "SQL"
- Copy the following 4 lines and paste them into the 'Script' text box:
truncate table {databaseOwner}{objectQualifier}SearchItemWordPosition
DELETE {databaseOwner}{objectQualifier}SearchItemWord
DELETE {databaseOwner}{objectQualifier}SearchWord
DELETE {databaseOwner}{objectQualifier}SearchItem - Check 'run as script'
- Click executive
- The search index will be rebuilt by the scheduler.
