you can able to create a cluster index per table , in a table you can either create a cluster index for one column or cluster index for multiple column named as composite clustered index, thumb rule is you can have only one clustered index it can be composite or non composite thanks & Regards DSS TRAINING SOLUTIONS
Cluster index will be automatically created, when a primary key is defined, for others we needs to do it manually. Thanks & Regards DSS Training Solutions
unique index allows one null but cluster index does not allow, also index seek will be faster for cluster index when we compare to unique index. hope this clarify. please share, subscribe and support us
Hii Bro, i have a question,,, you said,,,duplicate data's are not allowed in clustered index,,, and duplicate data's allowed in non clustered index.... and my query is... you r also saying we should not use duplicate for unique indexes,,,, then how come we can able to create clustered and non-clustered..in unique indexes??????
Content preparation in progress,Soon , the video on trigger will be published,keep support us , Subscribe and share with your family Thanks & Regards DSS Training Solution
Nice explain .
Thank you sir
Thanks , please subscribe and share with your friends
Very nice thanks bro🙏🙏
Welcome
very nice thanks
please subscribe and share with your friends & family
Thanks & Regards
DSS Training Solutions
Spr sir
nice explanation sir👌
thank you , keep support us, share with your friends and family
@@dsstrainingsolutionsdss4176 ❤️
Nice explain
Thanks for liking
i want to postgresql index breif explanation video...
Oru table'ku oru cluster muttum thaan create panna mudiyum'nu soldreenga.. 06:48
But Address table'ku 2 clusters create panni katureenga.. 09:00
Totaly Confused..
Will check your query and we come back
same how it is possible ? 9:02
@@dsstrainingsolutionsdss4176 Are you checked this? Please let me know ASAP.
@@AshokKumar-pw6ue sir.. avar solratha thappa solitaru.. but oru table oru cluster tha create pani irukaru..
@@bala3897Thank for your response
sir clustered also not supports the duplicate right then y we need unique ?
The storage type will be different, also u can have only 1 clustered index per table , but you can have multiple unique index in a table
bro mssql@sql server architecture videos podunga bro plss
sure bro will do it
Thanks & Regards
DSS TRAINING SOLUTIONS
For cluster index - 1 index per table, but multiple column index creation allowable ( both statements were contradiction). Why and how.
you can able to create a cluster index per table , in a table you can either create a cluster index for one column or cluster index for multiple column named as composite clustered index, thumb rule is you can have only one clustered index it can be composite or non composite
thanks & Regards
DSS TRAINING SOLUTIONS
which use index clustered and non-clustered
Do you explanations about c language for beginners to intermediate
if required , we can do , please confirm, but number of videos will be less
Thanks & Regards
Dss Training Solutions
Awesome
Thanks a lot , Please subscribe and recommend to our friends family to subscribe
Will all sql tables needs to create clustered/nonclustered index by user manually?
Cluster index will be automatically created, when a primary key is defined, for others we needs to do it manually.
Thanks & Regards
DSS Training Solutions
Bro nice video. What is difference between unique index and cluster index?
When to use unique index? What is the use of that?
unique index allows one null but cluster index does not allow, also index seek will be faster for cluster index when we compare to unique index.
hope this clarify.
please share, subscribe and support us
Hii Bro,
i have a question,,, you said,,,duplicate data's are not allowed in clustered index,,, and duplicate data's allowed in non clustered index....
and my query is... you r also saying we should not use duplicate for unique indexes,,,, then how come we can able to create clustered and non-clustered..in unique indexes??????
timings: 12:25
Triggers video pooduga bro
Content preparation in progress,Soon , the video on trigger will be published,keep support us , Subscribe and share with your family
Thanks & Regards
DSS Training Solution
Nowadays cluster index are used most frequently. Correct
YeS
please subscribe and share with your friends & family
Thanks & Regards
DSS Training Solutions
@@dsstrainingsolutionsdss4176 subscribed your channel. Will learn daily. Because i am a developer in pro c and plsql promoted from production support.
Can we create Clustered Index in SQL Developer tool?
Try to use scripts , that will help in executing your independently on tools
DSS Training Solutions