Index in mysql

Create index mysql

create index your_index_name on your_table_name(your_column_name) using HASH;
or
create index your_index_name on your_table_name(your_column_name) using BTREE;

Source: stackoverflow.com

Index in mysql

Ex. Explain select * from user where name = ‘kinjal’	#here explain is used for finding that how much time it takes to find name, how much rows in search.

Mysql select statement after index

   SELECT * FROM table1 USE INDEX (col1_index,col2_index)
    WHERE col1=1 AND col2=2 AND col3=3;

Source: stackoverflow.com

What is the use of index in mysql table

Indexes are used to find rows with specific column values quickly. Without an index, MySQL must begin with the first row and then read through the entire table to find the relevant rows. The larger the table, the more this costs.

Similar codes

2 votes61 views1 answer
Foreign key example in dbms
SQL
0 vote94 views1 answer
Enable outgoing remote MySQL access
SQL
1 vote93 views1 answer
Sql alchemy with azuresql server
SQL
0 vote107 views1 answer
St_buffer mysql
SQL
2 votes91 views1 answer
Postgresql change value in column
SQL
0 vote101 views1 answer
Can we rollback in sql
SQL
1 vote143 views1 answer
Column with prefix in sql
SQL
3 votes91 views2 answers
To_char sql
SQL
0 vote111 views1 answer
Oracle search in date columns
SQL
0 vote157 views1 answer
Mysql get nested records
SQL