Re: Understanding RexCorrelVariable

2018-01-12 22:39 GMT+01:00 Julian Hyde : > > As far as I can understand RexCorrelVariable is like a reference to the > > "current row” > > Yes, that’s correct. > > Also, think of a join, say > > select * from Depts as d, Emps as e where e.deptno = d.deptno > > implemented as

Re: Understanding RexCorrelVariable

> As far as I can understand RexCorrelVariable is like a reference to the > "current row” Yes, that’s correct. Also, think of a join, say select * from Depts as d, Emps as e where e.deptno = d.deptno implemented as nested loops, reading from an index. Then the pseudo-code is for (Dept d

Understanding RexCorrelVariable

Hi, I am trying to understand the meaning of RexCorrelVariable With this query I get a Plan like this: Query: UPDATE tblspace1.tsql set n2=n2+n2,n3=n3+n2 WHERE k1=? -- Best Plan EnumerableTableModify(table=[[tblspace1, tsql]], operation=[UPDATE], updateColumnList=[[n2, n3]],