Subject Re: [firebird-support] Performing bulk update taking time.
Author Dimitry Sibiryakov
27.04.2017 9:03, 'Joje' joje@... [firebird-support] wrote:
> Is there a way through which this query can be further optimised as this query taking time
> for completion more than 3 -4 hours. Could I use batch based update in this qu ery…?

Query in FOR SELECT does not need JOIN.
MERGE will do that in one shoot.