What causes poor performance at INSERT statements?
While SELECT, UPDATE and DELETE statements are being converted on the basis of execution plans, INSERT statements work according to a completely different mechanism based on free lists. Therefore, with INSERT statements, you cannot improve the performance by SQL tuning. Instead, you should analyze in detail the wait events that occur.
Related Questions
- Whats the best way, in terms of performance, to do multiple insert/update statements, a PreparedStatement or Batch Updates?
- How can I examine poor performance at INSERT statements?
- How can I examine poor performance at INSERT statements?
- What causes poor performance at INSERT statements?
- What causes poor database performance?
- What causes poor database performance?
