What would you use to improve performance on an insert
statement that places millions of rows into that table?
- 1 Answers
- 3157 Views
- I also Faced
- E-Mail Answers
Answer / saraswathi muthuraman
use Bulk collect insert and commit each set of transmission.
| Is This Answer Correct ? | 5 Yes | 0 No |
Explain the use of rows option in imp command.
List out the components of logical database structure of oracle database.
Explain the use of grant option in exp command.
What are the factors causing the reparsing of SQL statements in SGA?
What is the usage of analyze command in oracle?
How do I limit the number of oracle database connections generated by weblogic server?
How to update a table row with a record?
In Oracle 10g, "g" Stands for what?
If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
How many types of auditing in Oracle?
How can we Update a table with out using UPDATE command?
How to assign a tablespace to a users in oracle?
Oracle General 
