Subject computed lookup
Author jleroux2012
If have several computed columns which select values from the same table. example:

lu_branch_id_name varchar(120) computed by
((select from branch where = sos_batch.branch_id)),
lu_branch_id_accnr varchar(120) computed by
((select branch.accnr from branch where = sos_batch.branch_id))

Does the optimizer select the branch table only once or does it do a select for each computed column?