Friday, March 30, 2012

having the same definition for 2 indexes

CREATE NONCLUSTERED INDEX [operation_breakdown_machine_pk] ON [dbo].[operation_breakdown] ([machine_pk] ASC)WITH (PAD_INDEX = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF) ON [PRIMARY]

CREATE NONCLUSTERED INDEX [IX_operation_breakdown_machine_pk] ON [dbo].[operation_breakdown] ([machine_pk] ASC)WITH (PAD_INDEX = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF) ON [PRIMARY]

aren't they exactly the same? what are the possible effects of having the same definition for 2 indexes?

could it be possible that this has been overlooked by the administrator? i would just like to verify if this could have been done with intent or have been accidental.

thanks for any help!

I guess this would be accidental since having 2 identical indexes will not help you in any way. It will actually be worse for performance.
The effect is probably that SQL Server has to maintain two indexes.

|||thanks! it indeed was an accident.

No comments:

Post a Comment