CREATE INDEX idx_info_id ON pisp_publish_info (info_id) COMMENT 'index on INFO_ID'; CREATE INDEX idx_dict_code_value_code ON pisp_dict_val (dict_code, val_code) COMMENT 'index on dict_code, val_code';