on 08-10-2016 10:57 AM
Is table partitioning is available in sap sql anywhere 17?
SQL Anywhere does not support table partitions.
You can place indexes and tables in different dbspaces but a table or index can only exists in one dbspace. Without using multiple tables to store different subsets of the rows by a specific criteria (with obvious impact on the SQL and to usage), there is no way to break up a table into explicit pieces.
If there is a particular need for this maybe you can start a question about how to achieve a result for that without the use a single unsupported feature.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
76 | |
9 | |
8 | |
7 | |
6 | |
5 | |
5 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.