Clear Search Index

If by accident the search index got corrupted, there will be no serach results displayed any further and you have to delete the search index tables manually. Follow these steps:

  • Login as Superuser ("host" by default) 
  • In Host Menu select item "SQL"
  • Copy the following 4 lines and paste them into the text box:
    truncate table {databaseOwner}{objectQualifier}SearchItemWordPosition
    DELETE {databaseOwner}{objectQualifier}SearchItemWord
    DELETE {databaseOwner}{objectQualifier}SearchWord
    DELETE {databaseOwner}{objectQualifier}SearchItem
  • Activate the check box and hit Run
  • The search index will be rebuilt automatically by the scheduler.
© 2004-2005 gamma concept mbH