How can I examine poor performance at INSERT statements?
While SELECT, UPDATE, and DELETE statements are converted on the basis of execution plans, INSERT statements work with a completely different mechanism. With INSERT statements, there is no option of improving the performance by using SQL tuning. Instead, you need to thoroughly analyze the performance problems that occur. To be able to analyze performance problems with Inserts, you should know how a record is inserted into a data page: If a record is inserted into the database on MaxDB, the system first finds the data page that is changed by the action. The required space is then made available if required by carrying out adjustment operations. The database administrator does NOT need to take ANY action for this! When you insert a data record: -> the data record is inserted into the target page at the end of the occupied data area, -> the system uses an entry in the item list that is at the end of each data page and that only contains the reference to the record to sort to keep at a min
