Managing Indexes in SQL Server As a database administrator, one of the key tasks you'll…