4paradigm / 4paradigm/OpenMLDB

Delete unused index when deploy sql

Open
#696 2 comments 1 reaction 1 assignee Claimed by @dl239 View on GitHub
enhancement
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

Open the contributing 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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.