Emptying the DotNetNuke search tables can considerably reduce the size of the DotNetNuke database. It requires access as a host superuser.
Having emptied the search tables they will be re-populated, but better optimised, with less items which are old.
To delete the existing DotNetNuke indexed content execute the following four lines, from the Host>SQL page
truncate table {databaseOwner}{objectQualifier}SearchItemWordPosition
delete {databaseOwner}{objectQualifier}SearchItemWord
delete {databaseOwner}{objectQualifier}SearchWord
delete {databaseOwner}{objectQualifier}SearchItem
The content of the site will be re-indexed by the scheduled task (every 30 minutes by default), or it can be triggered from the Host>Search Admin page. Click on Re-index Content
Version 5 of the Reports module caused an error with the indexing. To fix this turn off the indexing by issuing the following command on the Host/SQL page:
update {databaseOwner}{objectQualifier}desktopmodules set SupportedFeatures = 1 where FriendlyName = 'Reports'
