Clustered and nonclustered indexes in SQL Server with Example

In this video we will learn about
1. Different types of indexes in sql server
2. What are clustered indexes
3. What are NonClustered indexes
4. Difference between clustered and non clustered indexes

[@shivaninayak6661]

Well explained , "non clustered index is like table of contents " This was very clear statement to understand. Thank you sir 👏👏👌👌👌👌

[@marriyam_here]

👍 it's very helpful and informative sir g

[@aniketjagdale7765]

The best video on index I have seen till now just one request show us some examples also means how non clustered index will work

[@hindustanzindabaad8683]

Mashallah thanks sir please make video on stored procedure and trigger

[@butterfly7976]

very nice video, well explained

[@technicalkashmiri6981]

thank you sir you make good understanding lectures

[@Asingh-hs8ud]

Good job.. nice explaination

[@abhinavsingh4208]

Gajab video bhai

[@tahirkahn4602]

JazakAllah sir ge

[@chairmanar2161]

great sir

[@shadabmulla6645]

Nice explain

[@aqmahi7106]

Mashallah

[@GCP899]

So every pk must have clustered index or you can say it must have unique index, is it?

[@irtassamArshad]

Alwa

[@chandudevarapu1578]

When ever we execute (execute sp_helpindex table1) this statement automatically one cluster index will be created on p-key right?

[@technicalkashmiri6981]

this statement is used just checking Number of index details on a table this is not used for creating index on a table ,more over if you pk automatically creat cluster index then first you drop pk-index before creating another cluster index on a table

[@mahijan5319]

Ap ki awaz kamal hai

[@shashankpandey1019]

Always confused to me that - How to decide when to use clustered and when to use non clustered index?

[@poojapawar1481]

Me to

[@ranjitbhosale8079]

gender DESC ???
10:38
i don't see gender in desc order.

[@harishgurav8119]

Because we did not had any duplicate salary to further order them by gender in descending

[@chandudevarapu1578]

Can you please explain in english

[@oluwanifemikim1996]

That's what he did
Just his ancent

[@slomoturtle3699]

great sir