Table partitioning in Sybase 9

[Former Member]

Good Morning!

Would you like to know how this command in Sybase9 ASA9 is?

create table fictionsales (store_id int not null, order_num int not null, date datetime not null) partition by range (date) (q1 values <= (“3/31/2004”) on seg1, q2 values <= (“6/30/2004”) on seg2, q3 values <= (“9/30/2004”) on seg3, q4 values <= (“12/31/2004”) on seg4);

Thank you

[VolkerBarth]

SQL Anywhere/ASA does not support table partitioning.

For very high loads, you might use the High availability and read-only scale-out features which are available for newer versions, but not for the very old version 9.