search

cockroachdb / cockroach

CockroachDB — the cloud native, distributed SQL database designed for high availability, effortless scale, and control over data placement.
https://www.cockroachlabs.com
Other
30.03k stars 3.8k forks source link

sql: forcing join types is difficult with ORMs #40988

Open awoods187 opened 5 years ago

awoods187 commented 5 years ago

In a recent customer issue (https://github.com/cockroachlabs/support/issues/332) we identified a need for a customer to use a lookup join hint. Unfortunately, this can be difficult to do with ORMs.

We need a solution that can allow a user to force a particular join when using ORMs.

Another workaround considered is to inject stats on a per-table basis that will trigger a different join type. This is not ideal because it requires sophistication to inject statistics and it requires the ability to control automatic statistics on a per-table basis.

Jira issue: CRDB-5497

github-actions[bot] commented 3 years ago

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 5 days to keep the issue queue tidy. Thank you for your contribution to CockroachDB!

rytaft commented 3 years ago

Still relevant.

github-actions[bot] commented 1 year ago

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!

rytaft commented 10 months ago

still relevant