Skip to Content
0
Dec 29, 2014 at 09:22 PM

Setting up semantic partitions ASE

38 Views

Running ASE 15.5

We have a non-partitioned table with 640 million rows. We are looking at setting up range semantic partitions by create date

There are 200 + million rows for 2013 and 380 + million rows for 2014

I am thinking about setting up following partitions by create date:

Partitions 1 - 4 : For 2015 By quarter

Partition 5 - For year 2014


Partition 6 - 2013 and and earlier

Add new Partitons for each new year ...

Only updating current data -- i.e. any data more than month old is no longer updated ..

Is this a viable breakdown ?

1st attempt at partitioning ..