4paradigm / 4paradigm/OpenMLDB
Delete unused index when deploy sql
- Langage dominant
- C++
- Étoiles
- 1.7k
- Forks
- 331
- Merge moyen
- 12 j 12 h
- PR mergées (30 j)
- 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
Guide de contribution
Ouvrir le guide de contribution
Piste de recherche
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.
Rédigé par le modèle d'indexation à partir du texte de l'issue.
Évaluation
- Stack technique
- sql
- Domaine
- databases, machine-learning
- Type d'issue
- Fonctionnalité
- Difficulté
- 4/5
- Temps estimé
- 3-5 jours
- Activité
- À l'abandon
- Clarté
- Plutôt claire
- Accessibilité débutants
- 45/100