search

cockroachdb / docs

CockroachDB user documentation
https://cockroachlabs.com/docs
Creative Commons Attribution 4.0 International
190 stars 460 forks source link

PR #101178 - opt: inverted-index accelerate filters of the form j = ... and j IN #16773

Open cockroach-teamcity opened 1 year ago

cockroach-teamcity commented 1 year ago

Exalate commented:

Related PR: https://github.com/cockroachdb/cockroach/pull/101178 Commit: [https://github.com/cockroachdb/cockroach/commit/85400d3c27913c3952f1a9206a6e040b61889d20](https://github.com/cockroachdb/cockroach/commit/85400d3c27913c3952f1a9206a6e040b61889d20] Informs: [CRDB-3301] Fixes: [CRDB-24268)

—

Release note (performance improvement): The optimizer now plans inverted index scans for queries using IN or the = operators without the fetch val (->) operator. eg: json_col = '{"b":"c"}' OR json_col IN ('"a"', '1')

Jira Issue: DOC-7478

exalate-issue-sync[bot] commented 1 year ago

Nick Vigilante (nickvigilante) commented: Mike Lewis The {{Epic:}} link in the description was pointing to a task that did not belong to an epic. The {{Fixes:}} link also points to a task that does not belong to an epic.