This content has been marked as final. Show 2 replies
Here is what I would suggest.
1 Start with Index compression first
2 Pick few largest indexes and compress them
3 Test the application for any anomalies
4 Pick few more Indexes and compress them
6 Start table compression with few biggest tables
I used similar method during the compression in our environment.
Your database size is not too large so you are in good shape and in better position to start the compression.
Hope this helps.
Pl also see these links
Pl make sure that you are licensed appropriately to use this feature.