Shrink & reindex, and elastic pool usage
Hi, I have recently reduced a PROD data table by several million rows but the Allocated table size has remained largely unchanged, as the reduction in the Used portion has just shifted to an increase...
Forum Discussion
Database shrinks run monthly (I believe the second Sunday of each month) as a part of OneStream's monthly maintenance window over a weekend. The shrink will run on any database that was marked as "production" during app creation or app copy. As far as I know this runs for all Cloud customers, so yes very widely used.
After deleting a bunch of data or table records, it is quite common that a database shrink would be needed, unless you are willing to wait for the monthly maintenance window.
There is a performance cost but normally if you work with support, they can schedule it during off or down hours.