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
- 6052 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 is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
what is the use of recording information about current session?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
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.
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
What are the different sql server versions you have worked on? : sql server DBA
what is the role of dip user in our database?
What are the operating modes in which database mirroring runs? : sql server DBA
How would you best determine why your MVIEW couldn't FAST REFRESH?
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.
how can you get actual data change values from previous transactions in oracle?
What is the default fill factor value? : sql server DBA
What is the default port no on which sql server listens? : sql server DBA
