3003135 - Trace flags 364 and 16982 are available for tuning suboptimal query plan having skew data in join columns - SAP ASE

A join query joining involving two or more tables is slow due to a suboptimal query plan.
There exists another faster query plan using a different index or different join order.
There exists join column with skew data, a related column histogram in optdiag output shows ‘Total density’ is much higher than ‘Range cell density’, e.g.

Statistics for column:                  "column_name"
Range cell density:             0.0001233381992404
Total density:                     0.3222680491657743

suboptimal query plan, CR 727887, 727887, Range cell density, Total density, trace flag 364, trace flag 16982

insert into #devicemap values(@DiskName,@PhysName,"disk_"+convert(char(10),@grp))

, KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Product Enhancement

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

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