Home » RDBMS Server » Performance Tuning » Updating compressed rows (All with compression options)
Updating compressed rows [message #631396] Tue, 13 January 2015 08:22
Messages: 1576
Registered: May 2010
Location: UK
Senior Member
Hi Smile

I found a damned useful entry on the impact of updating compressed data (having recently been burned by it) that I think is relatively little known so without further ado...


The "tl;dr" is a bulk update of a compressed table will highly likely result in significant row chaining and space increases.
Previous Topic: table lock in past
Next Topic: AWR - licensing question
Goto Forum:

Current Time: Fri May 24 02:21:22 CDT 2024