I have few Clarification regarding AWS RDS SQL Server.
Do we have any compression technique to compress the data loaded into RDS SQL server?
Is there any option or parameter to compress the data and load into RDS SQL server?
amazon-rdsawscompressionsql server
I have few Clarification regarding AWS RDS SQL Server.
Do we have any compression technique to compress the data loaded into RDS SQL server?
Is there any option or parameter to compress the data and load into RDS SQL server?
Best Answer
After you have loaded the data into a table, and as long as you have signed up for a 2016 Standard Edition or above, you can use the Data Compression that is included within Sql Server:
You can also create compressed indexes in a similar fashion:
For more information, check out the documentation for Enabling Compression on a a Table or Index.