Does rebuilding index reduce the physical size of the database?
Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.
No. if in the index rebuild, you result in less space being needed, then this simply remains as available free space in the data files.But it is possible that rebuilding indexes could result in increasing the physical size of the database
Thanks! Could you please explain in detail how rebuilding indexes could increase the physical size of the database
Various reasons:You may need space inside the files to create the new index - especially in ONLINE operations where the old index is still available for use whilst the new one is built.The new index may be larger than the old index, due to fragmentation (defined by the fill factor %)The rebuild operation is logged, so log file growth could be happening
17 People are following this question.
How to refresh a table alone
What is the difference between Bin and Binn folders
In SQL replication, what are the minimum rights/roles for the @subscriber_login used in sp_addpushsubscription_agent?
Sub Query help???
Issues with data synchronisation of a merge replication publication