Indexes in SQL Server | Use Indexes for Faster Search in SQL | SQL Interview Questions

For more such videos visit www.questpond.com
For more such videos subscribe www.youtube.co...
See our other Step by Step video series below :-
For more such videos subscribe / questpondvideos
See our other Step by Step video series below :-
JavaScript Interview Questions: • JavaScript Interview Q...
Learn SQL Server Step by Step tinyurl.com/ja4...
Learn MSBI Step by Step in 32 hours:- goo.gl/TTpFZN
Python Tutorial for Beginners:- • Python Tutorial for Be...
Learn Data Science in 1 hour :- tinyurl.com/y5...
Learn Power BI Step by Step:- tinyurl.com/y6...
PHP Interview Questions : • PHP Interview Question...
C# tutorial for beginners(4 hrs):- • C# Tutorial for Beginn...
Learn Azure Step by Step:- • Azure Tutorial for Beg...
Azure AZ-900 fundamentals certification :- • AZ 900 Certification |...
Angular Interview Questions and Answers :- • Angular Interview Ques...
Learn Angular tutorial step by step tinyurl.com/yc...
Learn MVC 5 step by step in 16 hours:- • Learn ASP.NET MVC 5 ( ...
Learn Design Pattern Step by Step goo.gl/eJdn0m
Learn Tableau step by step :- tinyurl.com/kh...
Preparing for C# / .NET interviews start here • C# Interview Questions...
In this SQL Server training video we will understand what are indexes and how they make your search faster. We also run through the fundamentals of B-tree or balanced tree structure. Its also one of those favourite SQL Server interview questions which is asked in SQL Server interviews.
We are also distributing a 100 page Ebook "Sql Server Interview Question and Answers". If you want this ebook please share this video in your facebook/twitter/linkedin account and email us on [e-mail] with the shared link and we will email you the PDF.
-----------------------------------------------------------------------------------------------
For more details :-
🌐 Website : www.questpond.com
📱 Mob. No. : [phone] / [phone] / [phone]
📧Email : [e-mail] / [e-mail] / [e-mail]
Share, Support, Subscribe and Connect us on!!!
KZbin: / questpondvideos
Twitter: / questpond
Instagram : / questpond
Facebook : / questpond
#SQLServerInterviewQuestions #LearnSQLServer #SQLServerQuestions #SQLServerTraining #SQLServerTutorial #WhatareIndexes #StructuredQueryLanguage #IndexesinSQLServer

[@questpondvideos]

20+ SQL Server Interview Questions : kzbin.info/www/bejne/iXbHcnluorh-iZY 20 MSBI Interview Questions : kzbin.info/www/bejne/hKjCpHt7gNOCi6c 10+ Power BI Interview Questions : kzbin.info/www/bejne/eaDdlGyNg6eFqpY SQL Server Joins : kzbin.info/www/bejne/gYXZint7o9mppJo SQL Step by Step - kzbin.info/www/bejne/q3jPl4NvpJyeo7s Software Architecture Interview Questions : kzbin.info/www/bejne/d6W3mJaYgbSkg68 Angular Step by Step Tutorial for Beginners : kzbin.info/www/bejne/Y2q5lIptgqd3qZo 25 Angular Interview Questions : kzbin.info/www/bejne/Y5vIoKx6f6mmia8 35 Important JavaScript Interview Questions : kzbin.info/www/bejne/kJOXlYOfbKh0hLc 30 Important C# Interview Questions : kzbin.info/www/bejne/eHzcn3h4hdacf68 25+ OOPS Interview Questions : kzbin.info/www/bejne/q2qcqHSld893rLM 25 Important ASP.NET Interview Questions : kzbin.info/www/bejne/ponQfpejf7p2Zsk 20 PHP Interview Questions : kzbin.info/www/bejne/Z5PTf4avo7qlopo 5 MSBI Interview Questions : kzbin.info/www/bejne/a3abYmiXjaaqj7M 20 MySQL Interview Questions : kzbin.info/www/bejne/b5nJm3Zjd9WMaJI

[@dnfvideo]

Either clustered or non-Clustered it creates a Btree structure. Split happens when its exceed 8 kb page size.

[@questpondvideos]

Angular, MVC core starting 16.07.20, Every Thursday at 9 PM. Syllabus explained in the video if needed the syllabus do email at [e-mail]. If Interested share this video on your FB, Twitter, and Linkedin and avail today's training free. kzbin.info/www/bejne/g5PPg4WnoclknMk

[@mineispolson]

This is awesome. First video which explain how the index make search faster with Example.

[@AP-sb3vl]

Clear and neat explanation. Great job,really appreciate the effort !

[@chandrageetham]

simply clear nerration with apt example to grasp. All the best

[@karankatam6684]

Simple and neat!!!!!! Got an interview and this helps!!!!! Thank you sir!!!!!!

[@prakashpasupathy1612]

Shiv, good video and I gained better understanding on Indexes. Thanks shiv. 1) You've said that Indexes create B-Tree, This is applicable for clustered index right for non-clustered index it won't create B-Tree right? 2) You've said, while creating index, it creates B-Tree and which in-turn organizes the data in B-Tree fashion. so on what basis the split happens? means how split of data happen? Thanks, Prakash.

[@authoenthu]

Simple ..wot it is , how it is done ..this is wot we need ..amazing

[@kingsleyyetoh7283]

This video got me subscribing without even knowing, lol. In what scenerio do we use non clustered indexes?

[@manojtate9604]

I loved it! The explanation was top-notch

[@questpondvideos]

SQL Server training and interview question:-What is index and how does it make your search faster ?.

[@soumenr2168]

You make things easy and digestive ... Thank you so much .

[@aksandesi1919]

Relly very inspiring sir. Good and go on. You are really an ideal for the future oriented candidates.

[@anilsthanam409]

Excellent explanation

[@maedehshahabi4744]

Thank you so much it was very helpful. Clear with a good accent.

[@fayechang8647]

Thanks it's really clear

[@nareshar8237]

you were didn't explain clustered and non-clustered differences

[@creativestatus9820]

thanku

[@RamSagarMourya]

thanks for sharing this video. looking forward to the second part of this video.

[@AkshayBopshetti27]

Something I was searching for a longgg time! Appreciate your efforts behind the video! Thanks! 🙏

[@databaseknowledge465]

Very well explained

[@udayakula3664]

Very clear explanation ...Yu rock....

[@questpondvideos]

👊👊👊👊👊👊Smash Subscribe button if you like it.👊👊👊👊👊👊

[@venkataprasadkistam2705]

beautiful and clear explaination thanks a lot

[@jonathanzuniga3681]

Thank you, this is a great video! I appreciate the thoroughness and attention to details. Ever consider teaching? Looking forward to more posts!

[@vison819]

perfect explanation about B-tree index

[@showyou1197]

Simple and awesome

[@AjaySingh-dr5ry]

Nice language sir and topic explain also

[@sidharthmandal9957]

I have one question..in the B_TREE structure. How come it is defining the range? like in the root node it is -----> [ 30 | 50 ] ??? how come it is defined?

[@gplus46]

Nice. Your diagram made it easy to follow you. Thanks!

[@fastdrive55]

Great video- summarizing the main points.

[@Kuraby]

thank you!!

[@fatfati_wale]

i like way of explanation ..very helpful

[@vandanasuryawanshi2213]

Thank u so much for making it simple. Is there any video on clustered and non clustered index?

[@donovan30081995]

Thank you so much for this video :)

[@digant83]

Very well explained. Thank you very much.

[@its_bijay_adhikari]

Thanks! Helped me alot to understand!!

[@JeraldJamesCapao]

Thank you. ^^

[@questpondvideos]

We are also distributing a 100 page Ebook "Sql Server Interview Question and Answers". If you want this ebook please share this video in your facebook/twitter/linkedin account and email us on [e-mail] with the shared link and we will email you the PDF.

[@bharathreddygali]

Hello pls email me the interview questions

[@bibigabuyo1654]

Thank you for this, really helps a lot!

[@sanjeebamat4485]

thank you so much sir for explanation appreciate you.

[@thisisgaurang]

Excellent sir !

[@jyotibarasker2792]

Whenever u upload the video how indexes decreases the performance let me know .Nice video

[@prasunjeetsoni6143]

please make a video in normalization deep analysis.. coz I tried to learn it many times bt i could not understand after 3 NF .. Coz the mentor change the schema .. I want to know in a single schema .. if possible then Use Northwind for that... Thanks

[@questpondvideos]

Check this kzbin.info/www/bejne/fp7RgqyGbdhohZo

[@excessreactant9045]

This was a great vid :)

[@RibasFilms]

thank you so much for sharing this vid...you helped me alott!!

[@narojunaresh8437]

Sir, Can you explain clustered and non clustered indexes?

[@mohammedroshid7922]

Great job! Thanks a million

[@crummmycheese]

As always the best

[@hayat1410]

Its a good video but a little short,waiting for Clustered & Non Clustered,How to use & where to use etc..

[@ipsitapani8641]

Nice very nice tutorial

[@7to7media]

What is difference between Create table table _name( And Create table dbo.Table_name(

[@mnatum-v17]

thanks

[@malayshah8421]

Really good explanation :)

[@laurarankin4663]

Thank you!

[@sureshborade5671]

Nice explanation ..

[@chiggrens_playground3193]

Thank you very much, really appreciate!

[@srikanthsurabhis]

Thank you

[@ghanshamkashyup6235]

So easy

[@Flower_withanshi]

I assume this structure will be in recursion mode means non leaf node will also have b tree inside.. please confirm

[@ulysses1904]

Great videos, I appreciate the time and effort and the fact that they are free and educational. But I would like to offer some constructive criticism as it's always surreal to hear advanced technical presentations interspersed with "right?", "what do you call", etc. Also I have to ask, is the word "only" pronounced "one-ly" in some places or is that an error? Otherwise thank you for making this material available.

[@sidhant251]

Which software are you using

[@danew637]

thanks for the video

[@JanekBaranek]

Clever video, clever man ;)

[@SuperFrankbob]

Great Video! Is it possible to adjust the number of non-leaf nodes?

[@itipriya9224]

plz add a lecture on dominance index or similarity and dissimilarity index

[@questpondvideos]

Will forward your request to the technical team. Thanks for your input.

[@ynevet]

well done!

[@asifshaik5244]

Please explain the Clusterd and Non Clustered index

[@Ganeshay-09]

Please tell me... Sql server. will covere all topic of sql..

[@questpondvideos]

Below you can check what all topics we have covered in SQL Server course- www.questpond.com/learn-sql-server-step-by-step/cid9

[@saispark4934]

OUR LOGICAL READ WAS 146431 BEFORE INDEXING, AFTER INDEXING IT CAME TO 5,,THANKS

[@ynevet]

even if the search value was 10, a full table scan would be happen because it doesn't know about later 10th values.

[@rohitsotra2010]

I have one question here, how to determine root note? I can see here it is 30. But can you explain why only 30?

[@digant83]

Do you have same DVD package for Java as well ?

[@questpondvideos]

+Digant Shah Yes we have for Java, here is the link with details www.questpond.com/java/javaj2eedesignpattern.html

[@MrNoomiali]

Thanks now I understand how index is fast, lol other than book index pages blah blah explanation!

[@nareshar8237]

I have one question. I am using SQL Server2014 version. Before creating index I am trying fetch 14th record in a table, I have seen that in logical record appearing as 1. But after creating Index I am trying to search the same 14 th record and in logical record appearing as 2. Could please explain me this differences ??????????

[@pankajpatel2456]

please let me know how does the data is being divided in root nodes and non leaf nodes.

[@jayakottam]

Thank you, easy to understand

[@sagittariusguy2011]

Awsome!!!!

[@ErJanardhanJethi]

How does it work in case of String search?

[@nivethithanivetha921]

What does logical reads means ????

[@rohith.mohansai]

Where is the follow-up video of this? Can you please help me with the link?

[@SurendraTarai]

What is logical reads?

[@archanasaini5227]

I would like to ask , how index work in background?

[@Flower_withanshi]

what is version of mssql managemnt studio?

[@vipulshahi7552]

better

[@shivanishubham5575]

But you didn't show how sql server creates balance tree?? Please explain

[@gkmishra2009]

Sir you please provide video on WCF WEB API Angular 4 SVN

[@mnatum-v17]

how can we sort nonclustered index ?

[@questpondvideos]

+msstaui DB For Technical query mail us at [e-mail]

[@tyronesunde8314]

Please stop saying "you know." If I knew, I wouldn't be watching your good video.

[@Censtudios]

This microphone is pissing me off. Sorry, but I can't get beyond 0:40 into the video...

[@harmanpreetkaur5910]

Plz explain cursorcand sequences..

[@ManuelJordan317]

Was no covered the difference between: clustered and non-Clustered - anyway, thanks for the video!

[@saitejaaa1086]

Cluster means only we apply one condition on one table after using cluster index it will Start sorting the Id . Non cluster means we will apply the multiple columns in a single table by using the index

[@RahulKumar-vr4cm]

Microsoft Access.

[@atvo2950]

no one search by ID because they dont know your ID .

[@krishan63]

So past

[@thingsinthebox]

clear and have code examples, very good !

[@katiatkachenko5349]

thank you