Table Compression Introduced in Oracle9i Release 2
{"Image DocumentName": "Table Compression Introduced in Oracle9i Release 2", "Image ImageDescription": "Supports compression during bulk load operations (Direct Load, CTAS) Data modified using conventional DML not compressed. Optimized compression algorithm for relational data. Improved performance for queries accessing large amounts of data. Fewer IOs. Buffer Cache efficiency. Data is compressed at the database block level. Each block contains own compression metadata \u2013 improves IO efficiency. Local symbol table dynamically adapts to data changes. Compression can be specified at either the table or partition levels. Completely transparent to applications. Noticeable impact on write performance. Being self-contained is good b/c in order to read a compressed block we don\u2019t have to access \u2018other blocks\u2019 that contain the symbol table or compression dictionary. For example, IBM has a database-wide symbol table. So every time you read a block that is compressed \u2013 you also have to read the blocks holding the db-wide symbol table \u2013 meaning extra I/O. We don\u2019t have to do that!!", "Image XResolution": "37", "Image YResolution": "37", "Image ResolutionUnit": "Pixels/Centimeter", "Image Software": "SlidePlayer", "Image YCbCrPositioning": "Centered"}