All tables that were partitioned in earlier releases of Adaptive Server revert to a single partition during the upgrade process. Although the same commands are used to select, insert, and delete data with Adaptive Server release 15.0 (whether the table is partitioned or not), performance of your procedures may depend on the tables you are partitioning. If the tables revert to a single partition, repartition the tables.
By default, Adaptive Server uses the round-robin method to partition a table. Adaptive Server 15. 0 introduces these additional methods to partition tables:
List
Range
Hash
See What's New in Adaptive Server Enterprise and the Transact SQL User’s Guide for more information on partitions.
This section highlights some of the limitations of unexpected behavior when using partitions.
