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.
user login restricted to one database
passing parameters to a vbs file in command line
What is the difference between Bin and Binn folders
Sub Query help???
using one parameter to filter what date to use