4paradigm / 4paradigm/OpenMLDB
Delete unused index when deploy sql
- Dominant language
- C++
- Stars
- 1.7k
- Forks
- 331
- Avg merge
- 12d 12h
- Merged PRs (30d)
- 1
Description
OpenMLDB will create a default index if there is no index option in create statement. But this index may not be used in deployment SQL, which will use much memory. So we will delete the unused index when `Deploy` SQL
Contributor guide
Research direction
Look for the code that creates default indexes and the deployment SQL logic. Understand how indexes are tracked and which are considered 'unused' during deployment. The change likely involves modifying the index management logic in the deployment step to clean up unused indexes. Test by creating a table with a default index, deploying a SQL that doesn't use it, and verifying the index is removed without affecting performance.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- sql
- Domain
- databases, machine-learning
- Issue type
- Feature
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 45/100