CREATE UNIQUE INDEX idx_assignment_no ON assignments(assignment_no); CREATE INDEX idx_assignment_details_assignment_id ON assignment_details(assignment_id); CREATE INDEX idx_assignment_status ON assignments(assignment_status_id, deleted); CREATE INDEX idx_assignment_details_assignment_id ON assignment_details(assignment_id); CREATE INDEX idx_completed ON assignments(assignment_status_id, deleted, submit_date);