1. DNN daily cleanning:
Go to host>SQL (run as script)
====================================================
truncate table {databaseOwner}{objectQualifier}Eventlog
truncate table {databaseOwner}{objectQualifier}SiteLog
truncate table {databaseOwner}{objectQualifier}ScheduleHistory
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