1. Categories >> Software >> Databases >> DB Administration
  2. Suggest New Category

What would you use to improve performance on an insert
statement that places millions of rows into that table?

Question Posted / narmada kumari

Answers were Sorted based on User's Feedback



What would you use to improve performance on an insert statement that places millions of rows into ..

Answer / setaceo

1. DML Triggers to be DISABLED and then ENABLED once the
insert completed.
2. DISABLE the Clustered Index and then ENABLED once the
insert completed.
3. After completion of INSERT, Defragmentation should be
there.
4. After completion of INSERT, Statistics should be updated.
5. (Optional) If it is non-peek time & This is the only
activity is going on then, Database recovery mode should be
SIMPLE / BULK-LOGGED. ( It should not be there along with
other activities....)

Is This Answer Correct ?    4 Yes 0 No

What would you use to improve performance on an insert statement that places millions of rows into ..

Answer / 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

More DB Administration Interview Questions

what is the last version,the release date of that version and fix pack of ibm db2 udb?

0 Answers  

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.

0 Answers  

What the different types of replication and why are they used? : sql server DBA

0 Answers  

the process of adding a cpu in sql server is called..?

2 Answers   TCS,

How to start SQL Server in minimal configuration mode?

1 Answers  




Explain how you would restore a database using RMAN to Point in Time?

1 Answers  

Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

0 Answers  

Hot backup procedure?

2 Answers  

Where in the Oracle directory tree structure are audit traces placed?

1 Answers  

If CPU is very slow What can u do to speed up?

1 Answers  

Why does Oracle not permit the use of PCTUSED with indexes?

0 Answers  

What is the difference between LMT & DLT?

1 Answers   CTS,

For more DB Administration Interview Questions Click Here
Categories