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
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
What is dcl? : sql server DBA
Explain materialized views and how they are used.
how can you enable flashback feature?
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
What purpose does the model database server? : sql server DBA
what is asm?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
What is transparent data encryption? : sql server DBA
currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba
What is the difference between clustered and non-clustered index? : sql server DBA
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA
How do you trace the traffic hitting a sql server? : sql server DBA
What the different types of replication and why are they used? : sql server DBA
what is the role of dip user in our database?