2650070 - Performance problem with INTRA_PARALLEL & Compressed Indexes | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2650070 - Performance problem with INTRA_PARALLEL & Compressed Indexes

Symptom

Long running SQL queries involving compressed indexes and query degree > 1


Read more...

Environment

Db2 10.5 running FP8 or lower

Keywords

MEMORY_TABLE FDA WRITE SQLO_LT_SQLI_PARSCAN__parScanLatch DFT_DEGREE Query_Degree, IT18835, latch wait time , KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , BW-SYS-DB-DB6 , BW DB2 Universal Database , SV-PERF-DB-IBM , Performance messages related to the IBM databases , Problem

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.