Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Partitioning

187124Sep 9 2008 — edited Sep 10 2008
Hi, 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!

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 8 2008
Added on Sep 9 2008
#general-database-discussions, #index, #insert
9 comments
297 views