Hi:

> Try creating a compound index on T2 which combines the State, City,
> Street and Address columns (in that specific order), this should help at
> least a little.

Thanks much. I created index:

CREATE INDEX "PROPOWNER" ON "TENANTS"("STATE_TEN", "CITY_TEN",
"STNAME_TEN", "ADRESS_TEN", "MAXDATE");

and plan is now:

PLAN (T2 INDEX (PROPOWNER))
PLAN SORT (SORT ((T1 INDEX (PROPADD))))

and execution time is now under 2 seconds. Great.


Best regards