Thread: Multiple Insertion
05-05-09, 07:45 #1Registered User
- Join Date
- Dec 2003
- Karachi, Pakistan
Unanswered: Multiple Insertion
I have some questions related to multiple insertion for bulk load.
Q1. How much fast multiple insertion in case of insert into 6 tables through
or more than that by on select statement (every table get 39 million of
Q2. Is it possible to use /* + APPEND */ hint in multiple insertion?
Q3. if answer 'NO' for question # 2 than is it good to use multiple insertion
for tables more than 6 or above? which is best with APPEND hint or with
Q4. Is it good idea to use multiple insertion instead of single insert query
with append for large volume of data. because I m not sure but it may
effect temp segment as well.
Actually I am working with large amount of data migration activity and want to reduce my time of migration.
05-05-09, 17:10 #2Registered User
Provided Answers: 1
- Join Date
- Aug 2003
- Where the Surf Meets the Turf @Del Mar, CA
Please realize that sooner rather than later, multiple sessions will saturate the disk with an Input/Output (I/O) bottleneck & no additional performance gains will occur.You can lead some folks to knowledge, but you can not make them think.
The average person thinks he's above average!
For most folks, they don't know, what they don't know.
Good judgement comes from experience. Experience comes from bad judgement.