Let's ask this question in order to understand the impacts of the indexes structure on the database design. Disabling indexes before an important inserts to avoid performance issues. An index cannot be enabled, it's simply rebuild. I.e. the data is physically moved on the disk.