CREATE  INDEX [ab] ON [LAFCMS_association]([associated_id_a], [associated_id_b]) ON [PRIMARY]
GO

 CREATE  INDEX [container_id] ON [LAFCMS_membership]([container_id]) ON [PRIMARY]
GO

 CREATE  INDEX [item_id] ON [LAFCMS_membership]([item_id]) ON [PRIMARY]
GO

 CREATE  INDEX [location_id] ON [LAFCMS_membership]([location_id]) ON [PRIMARY]
GO