Database Tuning (MOSC)

MOSC Banner

Concatenated index - need advice

edited Apr 26, 2022 4:50AM in Database Tuning (MOSC) 15 commentsAnswered

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_

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center