>Check, if the following indexes exist:
>regular index on table1.element
>regular index on table2.element
>
>regular index on table1.beg_odometer
>regular index on table2.Beg_odometer
>regular index on table1.end_odometer
>regular index on table2.end_odometer
>regular index on table2.survey_year

Hi, Walter.

I have regular indexes on table2.element, table2.beg_odometer, and table2.survey_year. I tried adding the others you listed, but it didn't change the performance.

Thanks for the suggestion.