Can insert operations also be accelerated by keep pool buffering?
Under certain circumstances, yes. You must also always upgrade index blocks during insert operations. These index blocks must be read from the hard disk if they are not buffered. If you carry out mass inserts, you must also import a corresponding number of SUITABLE index blocks. A poor clustering factor of an index indicates an index that largely determines the runtime of the insert. Caution: Inserts that perform poorly are generally the result of other factors that must be investigated beforehand. You must carry out a detailed analysis in all cases.
