Compression advisor is used to estimate compression ratio of a particular table by executing compression advisor utility.
Benefits:
It can be used to estimate compression ratio of object/table , based on that we can go for the best possible compression method i.e. OLTP, Query Low, Query High, Archive Low and Archive High.
It also helps us to decide whether we will get optimal benefit of compression or not.
We can come to know how much storage free space we would get if we compress the tables which helps us to do better capacity planning for future requirement.
Following are the steps which need to performed to get the compression ratio of any object.
