oracle - Oracle 12c YYYYMM年月份字段的范围vs列表分区(Range vs List partitioning for YYYYMM year month field Oracle 12c)

Question

I have a table which holds monthly data differentiated by a column year month (YYYYMM, eg 201911).

(我有一个表，其中包含按列年份月份（YYYYMM，例如201911）区分的每月数据。)

We have been planning to partition the table by month however we are unable to decide between Range Partitioning & List Partitioning for this type of situation.

(我们已经计划按月对表进行分区，但是对于这种情况，我们无法在范围分区和列表分区之间做出决定。)

Oracle clearly recommends using range partitions for columns with date/timestamp.

(Oracle明确建议对带日期/时间戳的列使用范围分区。)

Does it have any adverse effect in performance if the column is number?

(如果该列为数字，是否会对性能产生不利影响？)

Also most of the queries on this table has year_month = ??

(此外，此表上的大多数查询都具有year_month = ??)

filter!!

(过滤！！)

  ask by pOrinG translate from so

Answer 1

等待大神答复