Let's say I have a table that looks like this:
CREATE TABLE Activity ( ActivityID int primary key identity(1,1) , ActivityName nvarchar(10), InactiveFlag bit )
with an index that looks like this:
CREATE INDEX Activity_Index on Activity ( ActivityName )
then for some reason, someone has created a second index:
CREATE INDEX Another_Activity_Index on Activity ( ActivityName, InactiveFlag )
is it definitely safe to delete the first index? Is it just taking up unneccesary disk space? Will the second index cover all cases of the first? The column ordering is definitely "ActivityName" first.