28.SQL Performance Tuning Interview Questions And Answers|Clustered and non clustered index in SQL

[@PandeyGuruji]

Subscribe My Vlog Channel: www.youtube.com/@pandeygurujivlog Subscribe Technical Channel: kzbin.info Facebook: facebook.com/pandeygurujivlog

[@paulwerdak5888]

Excellent video Pandey.

[@aniketjagdale7765]

As you said we have to drop the clustered index and then do insert. But you also said non clustered index is faster when dealing with bluk dml statements so can't we do one thing that after dropping the clustered index as it makes bulk insert slow we can create non clustered imdex on the same column where primary key is created and after that if we do insert then I think it will be more faster than normal insert what you say on this

[@dev6296]

Your all videos are ossum sir Thanks a lot Please make more videos on performance tunning and 2. purge and archive activity.In hindi 🙏 Please

[@SantanuPuhan]

Thank you sir

[@PandeyGuruji]

Welcome

[@Iamyou0075]

You're doing great job bro love you please upload more

[@PandeyGuruji]

Thank you, I will

[@annapurnap4977]

Instead of drop can we Disable the index and enable??

[@neerajtripathy6526]

One thing you have not mention that non clustered index root node will internally search the cluster index then find the record . Without sorting how can a query be faster