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 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…