Wednesday, May 18, 2011

What are advantages of compression on tables?

- They take less physical space then uncompressed columns hence reducing space cost
- They improve  system performance as less data will be retrieved per row fetched , more data is fetched per data block thus increasing data loading speed
- They reduce overall I/O

No comments:

Post a Comment