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
- 6074 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
how does an oracle clusterware manage crs resources?
What the different components in replication and what is their use? : sql server DBA
What are the commands you'd issue to show the explain plan for "select * from dual"?
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
how can a session indicate its interest in receiving alerts?
What is dcl? : sql server DBA
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
How would you best determine why your MVIEW couldn't FAST REFRESH?
Explain about your sql server dba experience? : sql server DBA
What is a correlated sub-query? : sql server DBA
I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me
how can you communicate with operating system files from oracle?
what is grd?
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
