dinol.softedge wrote:

> Plan:
> ------------------------------------------------
> PLAN (TBL_JOB_CARD_EMPLOYEE NATURAL)
> PLAN SORT (JOIN (JOIN (TBL_JOB_CARD NATURAL,TBL_CLIENT INDEX
> (RDB$PRIMARY2)),TBL_INSURER INDEX (RDB$PRIMARY3)))

This indicates that no index is used for
TBL_JOB_CARD_EMPLOYEE.JOB_CARD_ID. I guess this slows down the query
considerably.

HTH,
Set