Knowledgebase: DotNetNuke
How do I clear and rebuild Search Index in DotNetNuke
Posted by Sean Syed on 23 February 2013 05:09 PM

To clear/delete the search index tables manually. Follow the steps below:

  • Login as 'HOST' (Super user account)
  • In Host Menu select "SQL"
  • Copy the following 4 lines and paste them into the 'Script' text box:
    truncate table {databaseOwner}{objectQualifier}SearchItemWordPosition
    DELETE {databaseOwner}{objectQualifier}SearchItemWord
    DELETE {databaseOwner}{objectQualifier}SearchWord
    DELETE {databaseOwner}{objectQualifier}SearchItem
  • Check 'run as script'
  • Click executive
  • The search index will be rebuilt by the scheduler.
(2 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please enter the text you see in the image into the textbox below (we use this to prevent automated submissions).