Dear All,
I have difficulty with updating column records of one table from another table
columns, which have common columns for relation.
Executed query is as follow :
update elements E set E.END_I = (select n.node_num from nodes N
where (E.X_I =N.XI and E.Y_I = N.YI and E.Z_I=N.ZI) )
where ex
d for now, but I'd like to know what is the decent way of solving such
issues.
Regards,
hi,
did you try select instead of update to see if select return all records which
you try to update?
regards,
Karol Bieniaszewski
Oryginalna wiadomosc
Od: "Sonya Bl
Dear all,
I experience slowdown in execution of following statement. It almost takes
11.5 sec to complete,
total rows in table is 6677 is it expected execution speed or is there any
workaround that I can increase the
execution of speed?
Exeucuted Query:
update elements E set E.END_I = (select
@Set
>The above query cannot possibly use any index for the nodes table (well,
>I'm a bit uncertain about indexes defined with COMPUTED BY, but I doubt
Yes the query was not using the indices even if they are defined,
lately I learned from SO that indices are not used with expressions. An the
