SAP Knowledge Base Article - Preview

2112153 - How to recreate ESH join indexes which are corrupted in TREX


  • You have corrupt join indexes in TREX/BWA.
  • You want to recreate missing or corrupt ESH indexes.
  • Following messages in the traces:
    "Query will be processed, but probably with performance penalty (missing join statistics)".
    "Join attribute type mismatch".



  • SAP BASIS all versions.
  • SAP Enterprise Search all versions.
  • TREX for SAP CRM 4.0


SAP NetWeaver Enterprise Search all versions ; SAP NetWeaver all versions ; search and classification engine (TREX) for SAP CRM 4.0


2007, How to recreate ESH join indexes which are corrupt in TREX, esh_create_join_index, ESH_RECREATE_ALL_JOIN_INDICES, query, performance, missing, penalty , KBA , BC-TRX-ENG , TREX Engine , BC-EIM-ESH , NetWeaver Enterprise Search , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.