Hi Virgo,

Below are the details:

CRM_JOB_ITEMS Table - Two seperate indexes on independent columns

Index No. 1. FK_JOB,
Index No. 2. PK_JOB_ITEMS

PK_JOB_ITEMS column is primary key and it also has seperate index on this single column

There are four other indexes as well on independent columns
-------------------------------

CRM_DOCUMENT_ITEMS Table - No index on "FK_JOB_ITEM" column which is used for inner join

Index No. 1 - FK_DOCUMENT_HEADER

There are two other indexes as well on independent columns

-------------------------------


CRM_DOCUMENT_HEADER Table - PK_DOCUMENT_HEADER is primary key and having seperate index on this column as well

There are two other indexes as well on independent columns, one of them index is on FK_JOB column as well (single column in its index)

With Best Regards.

Vishal