What would you use to improve performance on an insert
statement that places millions of rows into that table?
Answer Posted / braj123
Check that any indexes are there.
Drp the indexes and recreate after insert.
Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba
How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?
What is a correlated sub-query? : sql server DBA
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
how can you find out if a table can be redefined?
Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.
what are the benefits of flashback feature?
how to restore files with rman?
who owns the operating system files created by the utl_file package?
I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me
how can you connect from 10g user to 11g user??
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
what is logical system in sap basis
What are the commands used in dcl? : sql server DBA
internal architecture