I have a table which holds monthly data differentiated by a column year month (YYYYMM, eg 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. Does it have any adverse effect in performance if the column is number?
Also most of the queries on this table has year_month = ?? filter!!