Hi friends,

I turned on the append mode on a table for improving mass inserts on that table.Does that impact select queries on that table later on??

Also as far as i remember cluster index is not possible on a table with append mode.Does the append mode truly improve the insert performance?? If so by what extent


Thanks

Yes, it does improve performance because DB2 will not spent any time in looking for free space on the pages but rather append the data right at the end. Naturally, this may cause more pages to be read at query time, which can have a negative performance impact.

As for the "extent" of the impact, it depends - as usual.

Just remember that with append, DB2 will not use empty space from rows that are deleted, it will always place new rows at the end of the table.

The performance improvement is probably not significant, but why don't you test it?

I tested it and I did not see a great deal of improvement..Thanks all for your help