I'm aware that there are substantial differences between Dropping and Disabling a CLUSTERED Index, but I want to know about NON-CLUSTERED indexes.
And I'm aware that Disabling an Index retains the Metadata of the index definition, making it easier and lower maintenance to reinstate the Index afterwards.
But from a straight "Performance of INSERTs, UPDATEs and DELETEs" point-of-view ...
Is there any performance difference between having Disabled a Non-Clustered Index, and having dropped it entirely. Either during the table edits, or for the CREATE vs the REBUILD afterwards?