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!!

  • please publish the table creation statement – miracle173 Dec 1 '19 at 23:58

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.