ANSWERS: 1
-
No. Defragmenting a database moves the data so that it occupies one physical location on the hard drive, while compacting it reduces the amount of wasted space to make the data file smaller. Both of these operations improve the performance of the database.
Source:
Copyright 2023, Wired Ivy, LLC