Clarify that using LIMIT 1 still means your query touches more than one row

[rmloveland]

Richard Loveland (rmloveland) commented:

This came up during discussion about the error message for bounded staleness reads in cockroachdb/cockroach#71473

Since the error message says you can't (yet) touch more than one row with a bounded staleness read query, we need to make clear in the LIMIT docs and elsewhere that even though you are doing a LIMIT 1 multiple rows are being touched, and then filtered down to whatever your limit count is.

This update should probably also cross-link to SQL statement performance as well.

See also:

• Add docs on bounded staleness (follower) reads #11896

Jira Issue: DOC-1204

[github-actions]

We have marked this issue as stale because it has been inactive for
18 months. If this issue is still relevant, removing the stale label
or adding a comment will keep it active. Otherwise, we'll close it in
10 days to keep the issue queue tidy. Thank you for your contribution
to CockroachDB docs!