What would you use to improve performance on an insert
statement that places millions of rows into that table?
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
Which autogrowth database setting is good? : sql server DBA
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
how can you enable flashback feature?
. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?
how to restore files with rman?
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 communicate with operating system files from oracle?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
What is dcl? : sql server DBA
What types of replication are supported in sql server? : sql server DBA
how can you initialize log miner?
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
How to start SQL Server in minimal configuration mode?
What the different components in replication and what is their use? : sql server DBA
How would you extract DDL of a table without using a GUI tool?