2041052 - How can a table with existing data and no clustered index be round-robin partitioned with evenly distributed data? - SAP ASE | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2041052 - How can a table with existing data and no clustered index be round-robin partitioned with evenly distributed data? - SAP ASE

Symptom

  • 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? 

Read more...

Environment

SAP Adaptive Server Enterprise (ASE) all supported versions

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; Sybase Adaptive Server Enterprise 15.0 ; Sybase Adaptive Server Enterprise 15.5

Keywords

partitions,index , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , How To

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.