18 Jul 2014
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.
18 Jul 2014
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. |
Hi All,
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.
Thanks!
paddy