SAP Knowledge Base Article - Preview

2690547 - Performance issue using sp_drv_bcpmetadata on syscolumns - SDK for SAP ASE

Symptom

  • Bad performance with ps_drv_bcpmetadata when syscolumns has fragmented index
  • ASE uses table scan instead of index scan

Read more...

Environment

  • SAP Sybase Software Developer Kit (SDK) 15.7
  • SAP Adatpive Server Enterprise (ASE) Software Developer Kit (SDK) 16.0
  • jConnect
    • JDBC 7.07
    • JDBC 16 (is version 7.07)
  • Adaptive Server Enterprise ODBC Driver by Sybase
  • Adaptive Server Enterprise OLE DB Provider by Sybase
  • Adaptive Server Enterprise ADO.NET Data Provider
    • 3.5 Provider ( Sybase.AdoNet35.AseClient.dll )
    • 4.0 Provider ( Sybase.AdoNet4.AseClient.dll )
    • 4.5 Provider ( Sybase.AdoNet45.AseClient.dll )
  • java
  • odbc
  • oledb
  • .NET

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; SAP Adaptive Server Enterprise SDK 16.0 ; Sybase Software Developer Kit 15.7

Keywords

CR# 816515, CR816515, CR#816515, performance, table scan, index scan, csyscolumns, , KBA , BC-SYB-SDK , SDK , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , 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.