Concatenated index - need advice
Dear Experts,
SQL query
select sevadipreg0_.SEVA_DIP_REG_ID as SEVA1_137_, sevadipreg0_.CHANNEL_TYPE_ID as CHANNEL15_137_, sevadipreg0_.CREATED_BY as CREATED2_137_, sevadipreg0_.CREATED_TIME as CREATED3_137_, sevadipreg0_.EMAIL_NOTIFICATION_ID as EMAIL16_137_, sevadipreg0_.NO_OF_PERSONS as NO4_137_, sevadipreg0_.NO_OF_TICKETS as NO5_137_, sevadipreg0_.ROW_STATUS as ROW6_137_, sevadipreg0_.SERVICE_TYPE_ID as SERVICE17_137_, sevadipreg0_.BOOKING_ID as BOOKING7_137_, sevadipreg0_.SEVA_DATE as SEVA8_137_, sevadipreg0_.SEVA_DIP_FORM_ID as SEVA9_137_, sevadipreg0_.SEVA_DIP_SCHEDULE_ID as SEVA10_137_, sevadipreg0_.SEVA_ID as SEVA18_137_, sevadipreg0_.SMS_NOTIFICATION_ID as SMS19_137_, sevadipreg0_.TICKET_AVAILABILITY_STATUS as TICKET11_137_, sevadipreg0_.TICKET_PRICE as TICKET12_137_, sevadipreg0_.UPDATED_BY as UPDATED13_137_, sevadipreg0_.UPDATED_TIME as UPDATED14_137_, sevadipreg0_.USER_ID as USER20_137_