SAP Knowledge Base Article - Preview

2070085 - Static Cursor with ORDER BY Performance

Symptom

If a SQL Query results in a static cursor will existing indexes on the base table be used to optimize the ORDER BY clause?


Read more...

Environment

  • SAP Advantage Database Server (All versions)
  • Sybase Advantage Database Server (All versions)
  • Advantage StreamlineSQL

Product

SAP Advantage Database Server all versions ; Sybase Advantage Database Server all versions

Keywords

Sybase, standard, query, language, index, optimization , KBA , BC-SYB-ADS , ADS (Advantage Database Server) , 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.