Query on Vertical partitioning in Sybase

Question

hi,

Am working with sybase.In that i have a table A of some 2 million records containing some columns which i want to move out and make it as a separate table B. I have some questions in this process... 1. I have decided to use vertical partitioning.Is that ok? 2.Or what other technique can i go about using in this process?

Please provide your valuable inputs in this.

Thanks.

Answer 1

Vertical partitioning is moving columns to a new table. So in that process you can not use any other technique (all 'other' techniques are the same thing with different wording).