Discussion Board

Types of Compression There are two types of compression: 1. Row Level Compression 2. Page Level Compression 1. Row Level Compression: Row level compression is one of the type where there is no compression algorithm is used. The main aim of row level compression is to make fixed data types to a variable data type thereby reducing the size. This type of compression will remove any extra bytes in the fixed data type. One main consideration in this type of compression is that, data schema and data distribution directly plays an important role with respect to compression ratio. 2. Page Level Compression: Page level compression type can give more compression ratio compared to Row level. Page compression uses dictionary based compression algorithm to attain more compression ratio. The main aim of page level compression is to reduce column redundancy in one or more rows in a data page. Prajakta Pandit 03-7-2017 11:19 PM

plz give me runtime souliation this question i do real time pratice .but i have not recvied output plz send me souliation adi jangle 01-31-2015 08:10 AM

Write your comments