How do I clear and rebuild Search Index in DotNetNuke

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.