SAP Knowledge Base Article - Preview

3113618 - Table not automatically sorted on primary key or clustered index

Symptom

  • Table with primary key or clustered index is set
  • Select statement does not automatically maintain order by the primary key or clustered index
  • Only rebuilding the database or sort order fixes this problem
  • Documentation states table should maintain the sort order based on the clustered index but behavior is not observed


Read more...

Environment

Adaptive Server Enterpries

Product

SAP Adaptive Server Enterprise all versions

Keywords

datapages, datapage, datarows, datarow, allpages, allpage, sort by, order by , KBA , 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 for Me (Login required).

Search for additional results

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