- A table with existing data, but with no clustered index, may benefit from data partitioning.
- However, use of documented syntax for table partitioning does not evenly distribute data across partitions in every instance -- without a clustered index, partition creation on a table with existing data places all the data in the first partition.
- How can one ensure even data distribution when introducing round-robin partitioning on a table with existing data and no clustered index?
SAP Adaptive Server Enterprise (ASE) all supported versions
SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; Sybase Adaptive Server Enterprise 15.0 ; Sybase Adaptive Server Enterprise 15.5
partitions,index , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , How To
About this pageThis 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.