Mysql Index Tutorial | [Simple Explanation] [2020]
Автор: TechnoTrax
Загружено: 2020-10-22
Просмотров: 68809
Описание:
In this video, we'll see how basic Mysql Index concept works. We'll see how Mysql B-Tree index concept works with a simple example.
Power of Mysql Index: • Mysql Index Tutorial | Make websites 100 T...
Mysql Index works similar to how an index in a Book works. Mysql Indexes stored indexed column data in a separate storage in an Ordered List. When we search for a value, Mysql searches in the index column using the B-tree concept.
Mysql B-tree index works by first checking the middle value in the ordered indexed column, if the value is greater, it will continue to search on the right side of the column. If the value is lesser than the the middle value, it will search to left of the column. This method of search continues till it matches the value. This way, indexed columns need not scan all the rows of the table.
SUBSCRIBE: / @technotrax
Повторяем попытку...
![Mysql Index Tutorial | [Simple Explanation] [2020]](https://imager.clipsaver.ru/kv3jC0P4gOc/max.jpg)
Доступные форматы для скачивания:
Скачать видео
-
Информация по загрузке:
![MySQL Query Optimization Best Practices and Indexing [eng] / Alkin Tezuysal](https://imager.clipsaver.ru/9NHrZTIHwKA/max.jpg)
