Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What is the performance impact of using OLTP Table Compression?

April 26, 2017compression impact OLTP PERFORMANCE Table

0

Posted

What is the performance impact of using OLTP Table Compression?

1 Answer

0

Posted

For DML operations on a compressed table, Oracle Database’s specialized batch algorithm keeps the performance overhead to a minimum. Internal tests at Oracle showed a minimal overhead of less than 3% for a DML workload. In many cases, query performance will improve due to improved I/O efficiencies. During internal benchmarking tests, table scans on compressed table provided a three times improvement in performance i.e. scan on a compressed table completed in one third the time when compared to table scan on the corresponding uncompressed table.