query tuning

[ams-jamali]

1. I don't have up-to-date statistics on affected tables and indexes.I took that long back(may be 2-3 months).

2.
Table : JOB_QUEUE

INDEX NAME UNIQUE COLUMN
********* ****** ******
JOB_QUEUE_PK UNIQUE JOB_QUEUE_NR
JOB_QUEUE_QX11 NONUNIQUE JOB_QUEUE_TYPE_NR
JOB_QUEUE_QX12 NONUNIQUE STATUS_CODE
JOB_QUEUE_QX13 NONUNIQUE PERSON_NR


Table : PERSON

INDEX NAME UNIQUE COLUMN
********* ****** ******
PERSON_PK UNIQUE PERSON_NR
PERSON_AK_1 UNIQUE USERNAME
PERSON_IDX1 NONUNIQUE EMAIL
PERSON_QX101 NONUNIQUE STATUS_CODE

Table : REGIMEN_PRES

INDEX NAME UNIQUE COLUMN
********* ****** *******
REGIMEN_PRES_PK UNIQUE REGIMEN_TYPE_CODE
REGIMEN_PRES_PK UNIQUE PERSON_NR
REGIMEN_PRES_PK UNIQUE REGIMEN_SEQUENCE
REGIMEN_PRES_QX28 NONUNIQUE PERSON_NR


In regimen_pres table i have two index refer to same person_nr column.Here i have posted only the required column alone.