I would like to know If there would be any impact of I/O if we perform any join operations or filter operations on the compressed column considering compression property is majorly a space saving technique.
Hope I made myself clear.
IO would reduce due to MVC on any table. Even in a join and when reading from the table and writing into spool the read part would be less due to MVC.
In my understanding, MVC is not only to decrease the footprint of data on disk but improve access of the data also. compressed table would relatively need less spool and so less I/O thus need less CPU too to process it.
So MVC helps in using all resources efficeiently.