October 30, 2015 at 5:23 am
[font="Verdana"]Hi All,
Does rather than Dropping the Index, Disabling it would be the best approach? I have one stored procedure where Indexes are being dropped and recreated. So I was just wondering, would it be best approach to DISABLE them rather than DROPPING?
What would be the pros and cons?
Thanks,
Mahesh[/font]
MH-09-AM-8694
October 30, 2015 at 5:29 am
Mahesh Bote (10/30/2015)
[font="Verdana"]Hi All,Does rather than Dropping the Index, Disabling it would be the best approach? I have one stored procedure where Indexes are being dropped and recreated. So I was just wondering, would it be best approach to DISABLE them rather than DROPPING?
What would be the pros and cons?
Thanks,
Mahesh[/font]
Disable just retains the index definition. Whether you drop or disable it still has to be built\rebuilt to use it again
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 30, 2015 at 5:52 am
Just a word of warning - don't disable a clustered index. Because the clustered index is the table, disabling it will mean you won't be able to get to your data.
John
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply