Clustered and nonclustered indexes in sql server | SQL index | indexing in sql

Video talks about
what is clustered index in sql server
what is nonclustered index in sql server
difference between clustered and nonclustered indexes
sql clustered index
sql nonclustered index
Step by step SQL Training videos
SQL Tutorial
for more videos
/ @training2sqlmsbi

[@ArunKumar-wf4rf]

Clear explanation on clustered and non clustered index

[@Training2SQLMSBI]

Thanks for your feedback.

[@hemantkilanje8865]

Plz sir explain how work non clustered index.. How actually background It will create seperate space.. And how I will search key work

[@kadalibhargavi2691]

Very clear explanation thankyou sir

[@Training2SQLMSBI]

You're most welcome

[@pvarunkumar8106]

it's gud. u created the non clustered index, but , u r forgot to call the non clustered index. if u do that , it's better to us, yo know hw it's comes

[@RaMeShBaBu-gf1wc]

Super nice explanation ❤️❤️❤️

[@Training2SQLMSBI]

thanks for your kind words.

[@nickt423]

@8:04
I thought you can have a clustered index on only one column. Here you're saying you can have a clustered index on multiple columns?

[@hemantkilanje8865]

One table have only one clustered index... But we can create clustered index on multiple column ... Like primary key.... Even when we create primary key then clustered index automatically create on that table

[@naveenkumarp9874]

Super explanation clearly understand the topic😇 really thank you

[@Training2SQLMSBI]

Glad to hear that.. you are welcome..

[@asingh.singh70]

Lovely brother 🙏🙏

[@durgaprasadchalla6885]

super..without any distrubance

[@Training2SQLMSBI]

Thank you very much

[@sankarv1651]

Excellent sir

[@Training2SQLMSBI]

Many many thanks

[@baradiakshay8812]

can we create a cluster index without a primary key

[@mansoorshaik7263]

Yes you can create a Clustered Index with out a primary key, But when insert any records in a table like this the order of insertion will be same as your insert order ... But when you create Primary key a default Clustered Index will be generated and try to insert the records in any order but SQL Server engine will insert in ascending order (Default)create table test -- with out primary key and creating a clustered index
( id int,
name varchar(100))
Create Index IX_ID on test(id)
Insert into test values(2,'a')
Insert into test values(3,'b')
Select * from test
Insert into test values(1,'New')Drop the test table and create again with primary keycreate table test -- With Primary Key
( id int primary key,
name varchar(100))
Create Index IX_ID on test(id)
Insert into test values(2,'a')
INsert into test values(3,'b')
Select * from test
Insert into test values(1,'New')

[@akashpatil9865]

can we add multiple columns in non-clustered index?

[@DineshTelegenic]

Yes we can

[@vishnum7751]

Good article

[@Training2SQLMSBI]

Thanks for your feedback and appreciate your time..

[@MuthuPandi-lw2bl]

super

[@Training2SQLMSBI]

Thanks a lot for your feedback..
More videos on the same technology stack ..
ruclips.net/video/vbp2yPyUf9o/видео.html
ruclips.net/video/yUoDrqSRt6A/видео.html
ruclips.net/video/QOHxfeJ8VWE/видео.html
ruclips.net/video/x5iVbr94FqE/видео.html
ruclips.net/video/92OSTvW0Ge8/видео.html
ruclips.net/video/DBCCk8Yn7SM/видео.html
ruclips.net/video/NmqTJSHN8Ic/видео.html
ruclips.net/video/D8uiujYQTxw/видео.html
ruclips.net/video/upZsqwxZX2M/видео.html
ruclips.net/video/4EvEeN0pUBo/видео.html
ruclips.net/video/vwdeItscq7o/видео.html
ruclips.net/video/ZTSw89A1ZUg/видео.html
ruclips.net/video/sqX62jK0Vc8/видео.html
ruclips.net/video/DLn01pA1qcA/видео.html
ruclips.net/video/AFsuZ2XGlbg/видео.html

[@pathanibrahim1132]

What is the difference between clustered index and unique clustered index. Both are same? Please explain

[@hemantkilanje8865]

Unique clustered index is nothing but unique constraint. .. It will only uniquely identify records... And we can create multiple unique constraint on one table but one table have only one clustered index

[@yamalyamal6691]

@@hemantkilanje8865 nope

[@jasmeetsbhatia7]

Very nicely explained sir.