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 for Me (Login required).

Search for additional results

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