What would you use to improve performance on an insert
statement that places millions of rows into that table?
- 2 Answers
- 5204 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What are the steps you will take to improve performance of a poor performing query?
What are statistics, under what circumstances they go out of date, how do you update them?
what functionality does oracle provide to secure sensitive information?
how can you get actual data change values from previous transactions in oracle?
when does an alert gets signaled?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
How do you open a cluster administrator? : sql server DBA
How would you best determine why your MVIEW couldn't FAST REFRESH?
What is the default fill factor value? : sql server DBA
what is a user-defined lock?
Explain about your sql server dba experience? : 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?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
suppose you want to audit specific activities on sensitive data. How can you achieve that?
