How to add Btree or hash index to a table in mysql?
14,981
CREATE INDEX supports USING BTREE or USING HASH on the end.
http://dev.mysql.com/doc/refman/5.0/en/create-index.html
Related videos on Youtube
39 : 41
10.2 B Trees and B+ Trees. How they are useful in Databases
04 : 33
B-Tree Indexes
15 : 00
Learning MySQL - Using Indexes
27 : 43
Indexes In Mysql
11 : 30
SQL Advanced Videos #1: B-Tree and Clustered Index
![Mysql Index Tutorial | [Simple Explanation] [2020]](https://i.ytimg.com/vi/kv3jC0P4gOc/hq720.jpg?sqp=-oaymwEcCNAFEJQDSFXyq4qpAw4IARUAAIhCGAFwAcABBg==&rs=AOn4CLA2LqMngbtwlhQyfWj2rP2q6qUMHA)
06 : 56
Mysql Index Tutorial | [Simple Explanation] [2020]
08 : 11
Mysql Index Tutorial | Make websites 100 Times Faster!!! Query time from 2 Sec to 3 Milli Seconds
19 : 24
SQL căn bản - Bài 39: Tìm hiểu về Index trong SQL
04 : 48
MySQL - B-Tree Index Visual Representation
16 : 07
MySQL Composite Index Best Practices
03 : 08
Databases: MySQL - Optimal indexing for a lookup table. HASH index, BTREE index or composite PK?
01 : 00
How to add Btree or hash index to a table in mysql - MySQL
Author by
amir shadaab
Updated on September 03, 2022Comments
-
amir shadaab over 1 year
I have two tables and two queries on those tables. I am using SQL workbench to query these tables. Can someone tell me the syntax of adding BTREE or HASH index to these tables?
-
amir shadaab over 11 yearsWhich one is the default type?
-
Kevin Brown over 6 yearsBTREE is the default.
-
dwkd about 5 yearsalso HASH indexes are only for in-memory tables (or NDB) but not myISAM or InnoDB
