>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.
Bridget K. Dawes