A Survey on Database Index Tuning and Defragmentation

Опубликовано: 26 Февраль 2022
на канале: IJERT
14
0

👇Download Article👇

https://www.ijert.org/a-survey-on-dat...
IJERTV9IS120148
A Survey on Database Index Tuning and Defragmentation

Mounicasri Valavala , Dr. Wasim Alhamdani

Database performance tuning is an evolutionary field and is considered a difficult task, especially with large databases. Indexing contributes largely to improve the Database performance by reducing the query response time. The two main areas of indexing are selecting and maintaining the index. Selecting the right index by balancing the cost of data retrieval/manipulation and maintaining the index without fragmentation are challenging tasks with growing data requirements. There is extensive research to automate index tuning and limited research in index defragmentation. This paper provides a survey of research in index tuning and defragmentation techniques proposed in the last decade and the need for using robust technology like Machine Learning (ML) to overcome the limitations of the existing research.


Смотрите видео A Survey on Database Index Tuning and Defragmentation онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь IJERT 26 Февраль 2022, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 14 раз и оно понравилось 0 людям.