What would you use to improve performance on an insert
statement that places millions of rows into that table?
- 1 Answers
- 3043 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 |
What is an oracle cursor variable?
How to add another datafile to a tablespace?
Can the default values be assigned to actual parameters?
How to assign a table row to a record variable?
Can a Tablespace hold objects from different Schemes ?
3. Adapt your query in (2) above so that only post codes with more than twenty orders are displayed.
What is tns entry?
hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.
What are the restrictions in a oracle read only transaction?
What is a data segment ?
if i am using dml statement in function. then i am writing select statement what was the output
Can group functions be mixed with non-group selection fields?
Oracle General 
