What would you use to improve performance on an insert
statement that places millions of rows into that table?
- 2 Answers
- 5223 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / braj123
Check that any indexes are there.
Drp the indexes and recreate after insert.
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
what is the role of dip user in our database?
what is asm?
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 the difference between dropping a database and taking a database offline? : sql server DBA
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 is the default fill factor value? : sql server DBA
What is replication? : sql server DBA
What are the steps you will take to improve performance of a poor performing query?
What is the difference between clustered and non-clustered index? : sql server DBA
How would you best determine why your MVIEW couldn't FAST REFRESH?
what is grd?
What happens on checkpoint? : sql server DBA
what is logical system in sap basis
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
what are the differences of where and if in SAS?
