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
Thanks, so sounds like performance will slow down when the shrink is being run but provided we run a shrink followed by a reindex during off/down hours then there should be no downturn to performance the next day (in fact, performance may actually improve)?
In general, yes. The shrink and re-index do have a performance cost, which is why you want to pick an off-hours window. But after they are run, if your performance was related to not re-indexing a database in a while or not shrinking the database, then yes performance should improve. But that is with the caveat that performance depends on many, many factors.