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
What are statistics, under what circumstances they go out of date, how do you update them?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
What are the different types of upgrades that can be performed in sql server? : sql server DBA
Why would you use sql agent? : sql server DBA
Where would you look for errors from the database engine?
What are the different types of indexes available in sql server? : sql server DBA
What purpose does the model database server? : sql server DBA
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
What is dbcc? : sql server DBA
how to restore files with rman?
How would you extract DDL of a table without using a GUI tool?
Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.
how does an oracle clusterware manage crs resources?