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

What is non clustered index in MySql

A nonclustered index can be defined on a table or view with a clustered index or on a heap. Each index row in the nonclustered index contains the nonclustered key value and a row locator. This locator points to the data row in the clustered index or heap having the key value. The rows in the index are stored in the order of the index key values, but the data rows are not guaranteed to be in any particular order unless a clustered index is created on the table.

Post Your Comment

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