CREATE NONCLUSTERED INDEX ix_CM_REQUEST_TEMPLATECIndexBef ON CM_REQUEST_TEMPLATE (REQUEST_TEMPLATE_ID); CREATE NONCLUSTERED INDEX ix_CM_APPROVE_GROUPCIndexBef ON CM_APPROVE_GROUP (APPROVE_USERNAME);