SAP Knowledge Base Article - Preview

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

Symptom

  • 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".


Read more...

Environment

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

Product

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

Keywords

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.