When running a select query containing a join (with one of the datasets being indexed) via the HPCC JDBC driver, the resulting ECL code performs a non-keyed join and therefore does not leverage the index
I ran the following query via the driver. I've attached the resulting ECL code as well as the graph obtained from ECL watch.
select t1.mykey, t1.payload from ns::left as t1 inner join ns::rightDs as t2 USE INDEX(ns::rightIdx) on (t1.mykey = t2.mykey);
Can the driver be enhanced to leverage the index in this case and thereby execute a keyed join.
Attachments
1
Activity
Show:
Rodrigo Pastrana
June 8, 2017 at 3:11 PM
@Ashoka Kadambalithaya can you provide sample ECL that would make use of keyed Joins? Thanks.
Won't Fix
Pinned fields
Click on the next to a field label to start pinning.
When running a select query containing a join (with one of the datasets being indexed) via the HPCC JDBC driver, the resulting ECL code performs a non-keyed join and therefore does not leverage the index
I ran the following query via the driver. I've attached the resulting ECL code as well as the graph obtained from ECL watch.
select t1.mykey, t1.payload from ns::left as t1 inner join ns::rightDs as t2 USE INDEX(ns::rightIdx) on (t1.mykey = t2.mykey);
Can the driver be enhanced to leverage the index in this case and thereby execute a keyed join.