create unique index dt467_start_end_date_by_id on dt467 (
    di001218,  -- resource id

-- include other fields:

    di001230,  -- start date
    di001231)  -- end date
;
create index dt472_res_and_per_date on dt472 (
    di001517,  -- resource id
    di001460,  -- reconciled period date

-- include other fields:

    di001395,  -- project id
    di001400,  -- pos

    di001456,  -- reconciled actual effort
    di001457)  -- reconciled planned effort
