SAP Knowledge Base Article - Preview

3197633 - brconnect update statistics run 'ANALYZE INDEX ... VALIDATE STRUCTURE' internally and it slows down performance.

Symptom

When performing update statistics with following brconnect command, it runs 'ANALYZE INDEX ... VALIDATE STRUCTURE' internally for some tables's index.

It causes the index lock and slow down entire database performance.

brconnect -u / -c -f stats -t ALL


Read more...

Product

SAP NetWeaver 7.5

Keywords

brconnect ANALYZE INDEX,  statistics ANALYZE INDEX, brtools ANALYZE INDEX  , KBA , BC-DB-ORA-DBA , Database Administration , Problem

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.