Thanks,
I have searched a lot but didn't got a proper response.
If specifying Compression option in Create Table statement means an automatic compression in the table, then what will the threshold point when compression in fired.
I guess it won't compress the data after every dml operation ?