Do any of these COMPRESS options need the Advanced Compression license?
Basic compression is free. The OLTP compression is part of the Advanced Compression option. I will note this in the article.
Balraj Singh said...I test this in 184.108.40.206 and found that we can still have
COMPRESS FOR DIRECT_LOAD OPERATIONS,
COMPRESS FOR ALL OPERATIONS,
Shouldn't this all be replaced by COMPRESS FOR OLTP and mentioned in the article at top ? Pls advise.
You are meant to use COMPRESS FOR OLTP, but COMPRESS FOR ALL OPERATIONS is still a valid syntax, but it is deprecated, meaning it might be removed in a future release.
DO NOT ask technical questions here! They will be deleted!
These comments should relate to the contents of a specific article. Constructive criticism is good. Advertising and offensive comments are bad and will be deleted!
If you post personal information (name, email address etc.) you are agreeing to them being stored and displayed. Feel free to remain anonymous.