How to Delete DNN Useless Data and Clean the Search Index?

1.  DNN daily cleanning:

Go to host>SQL (run as script)

====================================================

truncate table {databaseOwner}{objectQualifier}SearchItemWordPosition

========================================================

2. Reindex dnn site's search:

First clean up the tables: host>SQL>run as script:

=========================================================

delete {databaseOwner}{objectQualifier}SearchItemWordPosition
delete {databaseOwner}{objectQualifier}SearchItemWord
delete {databaseOwner}{objectQualifier}SearchWord
delete {databaseOwner}{objectQualifier}SearchItem

==================================================

Then re-index the content:

host>search admin>re-index the content