Document `SELECT 1 + LIMIT 1` query issues with IN subqueries
Related to the incident Incident review: 2024-03-01: groupScanExecution... (gitlab-com/gl-infra/production#17840 - closed) document when does query plan flips happen and how to avoid them for .exists?
calls.
Edited by Adam Hegyi