January 15, 2016 at 9:53 am
Any thoughts on why the SSMS Table Object explorer tree - GUI not show any indicator (colour change or down arrow)
for Disabled Index?
Even RightClick menu option does not give an "Enable" option (which itself will be indicative of index being disabled in the first place)
Thank you,
Vinay
January 15, 2016 at 4:16 pm
datsun (1/15/2016)
Any thoughts on why the SSMS Table Object explorer tree - GUI not show any indicator (colour change or down arrow)for Disabled Index?
Even RightClick menu option does not give an "Enable" option (which itself will be indicative of index being disabled in the first place)
Thank you,
Vinay
Partly because there is no enable for an index. To enable a disabled index you need to use ALTER INDEX ... REBUILD ...
I agree, however, that the Object Explorer should have some indicator to let you know visually that an index is disabled rather than having to query sys.indexes and check the value of the is_disabled column.
January 16, 2016 at 11:25 am
It simply probably didn't occur to the SSMS developers at the time to visually mark it. They probably didn't deal with disabled indexes at the time and almost certainly not a lot of times.
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
January 20, 2016 at 6:14 am
Thank you both Lynn and Scott.
Have they improved in SQL 2012?
January 20, 2016 at 7:02 am
Just checked on my SQL2012 / SSMS 2012, and no, there's still no indication if an index is disabled, until you click into the properties.
January 20, 2016 at 9:00 am
And the same in SQL Server 2014. No indicator that the index is disabled.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply