vertical partitioning example

vertical_partitioning.sql

/* Consider the following table...*/
create table data (
     id integer primary key, 
     status char(1) not null,
     data1 varchar2(10) not null, 
     data2 varchar2(10) not null);
 
/* You can split via most frequent vs rarely used table columns */

create table data_main (
    id integer primary key, 
    status char(1) not null,
    data1 varchar2(10) not null );

create table data_rarely_used (
    id integer primary key,
    data2 varchar2(10) not null,
    foreign key (id) references data_main (id) );