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 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: [ Ссылка ]
Mysql Index Tutorial | [Simple Explanation] [2020]
Теги
Mysql Index TutorialMysql IndexesIndexes in SQLIndexessql indexescreate indexHow mysql index worksMysql Index explainedHow indexes workdatabase index explainedB-tree indexIndexed columnHow indexing woksMysql Index Tutorial with Simple exampleMysql index with exampleBasic Mysql index conceptIndexing in Mysqlwhat is index in sqlMysql Index for beginnersMysql index exampleHow does sql index workIndexes explainedHow to use sql index
