Interested to Buy Any Domain ? << Click Here >> for more details...
What would you use to improve performance on an insert
statement that places millions of rows into that table?
- 2 Answers
- 6212 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 the different topologies in which replication can be configured? : sql server DBA
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 can you connect from 10g user to 11g user??
how can you find out if a table can be redefined?
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?
what is grd?
how can you enable flashback feature?
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.
what do you understand by fine-grained auditing?
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.
Explain materialized views and how they are used.
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
What are statistics, under what circumstances they go out of date, how do you update them?
