is this a range_n partition or case_n partition?

Database
Enthusiast

is this a range_n partition or case_n partition?

Hi,

lots of the tables in our database are partition by YR. The create table syntax is like :

create table

(YR smallint,

...

)

Unique primary index (YR, ....)

partition by YR;

the constraint check under the dbc.indexconstraints is: CHECK ((YR) BETWEEN 1 AND 65535)

Is this a range_n partition or case_n partition?

Thank you!

3 REPLIES
Enthusiast

Re: is this a range_n partition or case_n partition?

Does anybody know about this?

Senior Apprentice

Re: is this a range_n partition or case_n partition?

Neither RANGE_N nor CASE_N. it's simply directly partitioned by YR.

Of course if YR means "year" you probably don't have a business which covers 65000 year, better use the correct range:

RANGE_N(YR between 1990 AND 2020 each 1)

Dieter

Enthusiast

Re: is this a range_n partition or case_n partition?

yes. That is a good recommendation.