Home >> MySql >> What is Index and why use indexing in MySql

What is Index and why use indexing in MySql

Indexing is a searching technique to improve the database performance.

There are two types of index-

1)-Clustered

2)-Nonclustered

Used

1)-An index is used to speed up searching in the database.

2)-An index can be used to efficiently findall row matching some column in your query and then walk through only that subset of the table to find exact matches.
 

Post Your Comment

Next Questions
What is clustered index
What is non clustered index
What is primary key index
What is unique key index
What is normal index
What is full text index
What are advantage and disadvantage of indexing
Create database
Drop database
Select database
Create table
Drop table
Truncate table
Insert query
Select table
Where clause
AND Clause
OR Clause
Update query
Delete query
Like clause
IN clause
Order By
Group By
Distinct keyword

Copyright ©2022 coderraj.com. All Rights Reserved.