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

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.