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 difference between dropping a database and taking a database offline? : sql server DBA
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
You create a private database link and upon
connection, fails with: ORA-2085: connects to
Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com
What the different topologies in which replication can be configured? : sql server DBA
What are the different types of upgrades that can be performed in sql server? : sql server DBA
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
what is the diffrence between core dba and apps dba?
What the different types of replication and why are they used? : sql server DBA
what are the differences of where and if in SAS?
can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com
What is the default port no on which sql server listens? : sql server DBA
What are the different types of database compression introduced in sql server 2008? : sql server DBA
What are the different sql server versions you have worked on? : sql server DBA