From time to time you may notice that the tables tied to the built-in DotNetNuke site search can grow quite large and in many cases consume large amounts of space.  This article defines a methodology to clear these tables and re-index the DotNetNuke site search.

Step 1: Clear Search Tables

• Navigate to Host > SQL
• Copy the following into the textbox:

delete {databaseOwner}{objectQualifier}SearchItemWordPosition

delete {databaseOwner}{objectQualifier}SearchItemWord

delete {databaseOwner}{objectQualifier}SearchWord

delete {databaseOwner}{objectQualifier}SearchItem

• Check Run as Script:
• Click Execute
   

Step 2:  Re-Index the Content

• Navigate to Host > Search Admin
• Click Re-Index the Content