Ismet posted on January 03, 2010 15:11
Sometimes you may need to clear
Search Index of DotNetNuke, when
Search functionality of your website is broken and
Search Results module throws errors.
Following
SQL code is useful for the scenario above.
truncate table {databaseOwner}{objectQualifier}SearchItemWordPosition
DELETE {databaseOwner}{objectQualifier}SearchItemWord
DELETE {databaseOwner}{objectQualifier}SearchWord
DELETE {databaseOwner}{objectQualifier}SearchItem

Just type the code under Host > SQL with Super user privileges and check Run as Script checkbox, then hit the Execute button.
I also published this tip under my personal Turkish blog for those
Turkish Community users. Following is the link to article.
DotNetNuke Arama Indeksini Yeniden Oluşturmak İçin Yapmanız Gerekenler