Impact of using a compressed column in any join or predicate clause in a query

Database
Enthusiast

Impact of using a compressed column in any join or predicate clause in a query

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

3 REPLIES
Enthusiast

Re: Impact of using a compressed column in any join or predicate clause in a query

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.

Enthusiast

Re: Impact of using a compressed column in any join or predicate clause in a query

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.

--Ashok

Enthusiast

Re: Impact of using a compressed column in any join or predicate clause in a query

Thanks all for clearing the doubt, henceforth i will keep that in mind :)