Partitioning
187124Sep 9 2008 — edited Sep 10 2008Hi, I need to know if I can speed up a massive insert statement like "insert into table t1 select * from tmp" partitioning the target table in the following way:
- The target table has more than 100 MM of record
- The partitioning criteria will be by load_date (Monthy)
- Every insert statement affect only one partition because will be referencing one load_date.
Thanks!