Printable View
Hi,
I have some questions to ask for help.
1,What are the factors affecting the insert statement in a sql statement?
2,How can I get the effect of parallel insert?
3,Say, if I want to improve the speed of inserting into a table, what should I do?
4,Will create table partitions help to improve the insert speed?
Our database is running on Sun Solaris, version 8.1.7
Thanks for help.
Dragon
Quote:
Originally posted by dragon99
Hi,
I have some questions to ask for help.
1,What are the factors affecting the insert statement in a sql statement?
2,How can I get the effect of parallel insert?
3,Say, if I want to improve the speed of inserting into a table, what should I do?
4,Will create table partitions help to improve the insert speed?
Our database is running on Sun Solaris, version 8.1.7
Thanks for help.
Dragon
1. The system I/O, network bandwidth, ARRAYSIZE.
2. Break them down to multiple smaller files and load them simultaniously.
3. Have the FREELIST set appropiately on the table, if you are on the multi processor system follow the step 2, disable all the indices and triggers on the table. Once you complete the insert rebuild your indices for that table.
4. If you have a bad network, then partition wouldn't help, but in general, partitioning across multiple tablespace should help you to a good extend.
Hope this would help you.
Sam
Thanks, Sam.
It is very helpful.