Constraints vs. indices will be improved in HHH-8737. However, the NO_CONSTRAINT issue I'll address here – good catch