WorkspacesToBeReturnedUpdater update query performance

Everyone can contribute. Help move this issue forward while earning points, leveling up and collecting rewards.

• Work on this issue
• Close this issue

MR Pending

Description

Check the expected max rows and improve WorkspacesToBeReturnedUpdater query update performance

Follow-up from "Force full reconciliation logic for workspaces"

Acceptance criteria

• Identify max number of records
• Solution: Do a batched update and consider doing a full update rather than partial