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

[@kadalibhargavi2691]

Very clear explanation thankyou sir

[@Training2SQLMSBI]

You're most welcome

[@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

[@ArunKumar-wf4rf]

Clear explanation on clustered and non clustered index

[@Training2SQLMSBI]

Thanks for your feedback.

[@naveenkumarp9874]

Super explanation clearly understand the topic😇 really thank you

[@Training2SQLMSBI]

Glad to hear that.. you are welcome..

[@hemantkilanje8865]

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

[@durgaprasadchalla6885]

super..without any distrubance

[@Training2SQLMSBI]

Thank you very much

[@sankarv1651]

Excellent sir

[@Training2SQLMSBI]

Many many thanks

[@asingh.singh70]

Lovely brother 🙏🙏

[@RaMeShBaBu-gf1wc]

Super nice explanation ❤️❤️❤️

[@Training2SQLMSBI]

thanks for your kind words.

[@akashpatil9865]

can we add multiple columns in non-clustered index?

[@TelegenicByDinesh]

Yes we can

[@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')

[@EquityandEverything]

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.

[@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

[@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