Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.6.17
-
None
Description
JOIN of 2 tables that residing on different servers by one common field, such as
select count(1) from t1 l inner join t2 le on l.lot_num = le.lot_num; |
exhibit performance issue.
It takes hours if t1 and t2 are on different servers. And a few minutes if tables are on the same server.