OLTP Table Compression

GPTKB entity

Statements (21)
Predicate Object
gptkbp:instanceOf database technology feature
gptkbp:appliesTo tables
partitions
indexes
gptkbp:benefit can improve query performance
reduces disk space usage
gptkbp:compressionRatio page-level compression
row-level compression
https://www.w3.org/2000/01/rdf-schema#label OLTP Table Compression
gptkbp:introducedIn gptkb:Oracle_Database_11g
gptkbp:limitation may increase CPU usage
gptkbp:notRecommendedFor tables with frequent updates
gptkbp:purpose improve I/O performance
reduce storage requirements
gptkbp:requires gptkb:Advanced_Compression_option_(Oracle)
gptkbp:supportedBy gptkb:Oracle_Database
gptkb:SQL_Server
gptkb:IBM_Db2
gptkbp:usedIn gptkb:Online_Transaction_Processing_(OLTP)_systems
gptkbp:bfsParent gptkb:Oracle_Advanced_Compression
gptkbp:bfsLayer 7