Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Make Expression Index generally available #18008

Closed
scsldb opened this issue Jun 15, 2020 · 2 comments
Closed

Make Expression Index generally available #18008

scsldb opened this issue Jun 15, 2020 · 2 comments
Labels
feature/accepted This feature request is accepted by product managers priority/P1 The issue has P1 priority. type/feature-request Categorizes issue or PR as related to a new feature.
Milestone
v5.0.0 ga

Comments

@scsldb
Copy link

scsldb commented Jun 15, 2020 •
edited by bb7133
Loading

Description

Since TiDB 4.0, one can put indexes on expressions, aka expression indexes. This feature is quite useful when dealing with JSON functions.

However, it is still an experimental feature: https://docs.pingcap.com/tidb/dev/sql-statement-create-index#expression-index

Warning:

Expression index is still an experimental feature. It is NOT recommended that you use it in the production environment.

We plan to make it stable enough to be production-ready in the near future.

Category

Feature, Performance.

Value

it helps to improve the performance of queries whose filter contains expressions.

Schedule

  • Start Date:2020-07-01
  • End Date: 2020-08-31
  • GanttProgress: 50%
@scsldb scsldb added priority/P1 The issue has P1 priority. type/feature-request Categorizes issue or PR as related to a new feature. labels Jun 15, 2020
@scsldb scsldb added this to the v5.0-alpha.1 milestone Jun 15, 2020
@scsldb scsldb modified the milestones: v5.0.0-alpha.1, v5.0.0-alpha, pools Jul 15, 2020
@scsldb scsldb added the feature/accepted This feature request is accepted by product managers label Jul 16, 2020
@ghost
Copy link

ghost commented Sep 1, 2020

As noted in the description, this is useful for JSON. But this use case is currently not supported by the optimizer due to a regression: #14456

@ghost ghost mentioned this issue Sep 10, 2020
Open
70 tasks
@scsldb scsldb modified the milestones: Requirement pool, v5.0.0-rc Oct 20, 2020
SunRunAway added a commit to SunRunAway/community that referenced this issue Dec 3, 2020
@SunRunAway
Propose @wjhuang2016 as committer of sig-exec
d08134e 
Since @wjhuang2016 has contributed a lot to sig-exec, according to sig-exec [roles-and-organization-management.md#promotion](https://github.com/pingcap/community/blob/master/special-interest-groups/sig-exec/roles-and-organization-management.md#from-reviewer-to-committer), we would like to promote him to our new committer, and his detailed contribution is shown below:

contribute [30 PRs](https://github.com/pingcap/tidb/pulls?q=is%3Apr+author%3Awjhuang2016+label%3Asig%2Fexecution) to the executor,
support the [expression index](pingcap/tidb#18008) (a medium task)
support the [new collation](pingcap/tidb#14573) (a hard task)
help other contributors and review [150+](https://github.com/pingcap/tidb/pulls?q=is%3Apr+reviewed-by%3Awjhuang2016+-author%3Awjhuang2016+label%3Asig%2Fexecution) PRs.
Thanks for his contribution!!
@SunRunAway SunRunAway mentioned this issue Dec 3, 2020
Merged
ti-chi-bot pushed a commit to pingcap/community that referenced this issue Dec 3, 2020
@SunRunAway
Propose @wjhuang2016 as committer of sig-exec (#362)
d8a1b49 
Since @wjhuang2016 has contributed a lot to sig-exec, according to sig-exec [roles-and-organization-management.md#promotion](https://github.com/pingcap/community/blob/master/special-interest-groups/sig-exec/roles-and-organization-management.md#from-reviewer-to-committer), we would like to promote him to our new committer, and his detailed contribution is shown below:

contribute [30 PRs](https://github.com/pingcap/tidb/pulls?q=is%3Apr+author%3Awjhuang2016+label%3Asig%2Fexecution) to the executor,
support the [expression index](pingcap/tidb#18008) (a medium task)
support the [new collation](pingcap/tidb#14573) (a hard task)
help other contributors and review [150+](https://github.com/pingcap/tidb/pulls?q=is%3Apr+reviewed-by%3Awjhuang2016+-author%3Awjhuang2016+label%3Asig%2Fexecution) PRs.
Thanks for his contribution!!
@jebter jebter modified the milestones: v5.0.0-rc, v5.0.0 Jan 18, 2021
@Defined2014
Copy link
Contributor

Close this issue as expression index is GA since v6.5

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
feature/accepted This feature request is accepted by product managers priority/P1 The issue has P1 priority. type/feature-request Categorizes issue or PR as related to a new feature.
Projects
None yet
Milestone
v5.0.0 ga
Development

No branches or pull requests
3 participants
@jebter @scsldb @Defined2014