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

asked 07 Mar, 07:54

Luiz%20Miguel's gravatar image

Luiz Miguel
113
accept rate: 0%


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.

permanent link

answered 07 Mar, 08:07

Volker%20Barth's gravatar image

Volker Barth
33.9k333487718
accept rate: 33%

edited 07 Mar, 08:12

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×107

question asked: 07 Mar, 07:54

question was seen: 164 times

last updated: 07 Mar, 08:12