Home >> MySql >> What is clustered index in MySql

What is clustered index in MySql

Clustered index(records ordered + non-key fields or non-primary key).

A clustered index sorts and stores the data rows of the table or view in order based on the clustered index key. The clustered index is implemented as a B-tree or B++ tree index structure that supports fast retrieval of the rows, based on their clustered index key values.

Post Your Comment

Next Questions
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
Sorting

Copyright ©2022 coderraj.com. All Rights Reserved.