how to determine if we can delete the index can be removed

• 892717952

  SSC Eights!

  Points: 843

  More actions

  June 6, 2023 at 6:35 am

  #4205387

  In SQL Server database, there is a table InventDim with two indexes: Idx1 with index columns (DataAreaID, BatchID) and Idx2 with index columns (DataAreaID, BatchID, InventSizeID). Is it possible to drop Idx1 if Idx2 already exists and covers all the columns in Idx1?

• Erland Sommarskog

  SSC-Insane

  Points: 24038

  More actions

  June 6, 2023 at 9:28 am

  #4205460

  Duplicate question. See https://www.sqlservercentral.com/forums/topic/how-to-determine-if-we-can-delete-the-index-can-be-removed for answer.

  [font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]