SAP Knowledge Base Article - Preview

2650237 - Join on encrypted columns running extremely slow

Symptom

  • The two columns in the join are encrypted with same key
  • The two columns have the same datatype
  • The two columns are not part of an expression(t.encr_col1 = s.encr_col1 +1)
  • The encryption key was created with init_vector and pad set to NULL
  • The join was using the "=" operator
  • Sort order was set to Sort Order = 52, nocase_iso_1


Read more...

Environment

  • SAP Adaptive Server Enterprise(ASE) 12.5.3a
  • SAP Adaptive Server Enterprise(ASE) 15.0x
  • SAP Adaptive Server Enterprise(ASE) 15.7x
  • SAP Adaptive Server Enterprise(ASE) 16.0x

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

Encrypted Columns joins performance table scan , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-SYB-ASE-CE , ASE Cluster Edition (Standalone) , 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.