cancel
Showing results for 
Search instead for 
Did you mean: 

SAP SQL ANYWHERE 17

Former Member
0 Kudos

Is table partitioning is available in sap sql anywhere 17?

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

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.