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

Подписаться 213 тыс.

Просмотров 401 тыс.

50% 1

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 questpond@questpond.com with the shared link and we will email you the PDF.
-----------------------------------------------------------------------------------------------
For more details :-
🌐 Website : www.questpond.com
📱 Mob. No. : +91-9967590707 / +91 7700975156 / +91-22-49786776
📧Email : questpond@questpond.com / questpond@gmail.com / questpond@yahoo.com
Share, Support, Subscribe and Connect us on!!!
RU-vid: / questpondvideos
Twitter: / questpond
Instagram : / questpond
Facebook : / questpond
#SQLServerInterviewQuestions #LearnSQLServer #SQLServerQuestions #SQLServerTraining #SQLServerTutorial #WhatareIndexes #StructuredQueryLanguage #IndexesinSQLServer

Опубликовано:

28 сен 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 105

@questpondvideos 3 года назад

20+ SQL Server Interview Questions : ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-SEdAF8mSKS4.html 20 MSBI Interview Questions : ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Nw_sHEKnOUE.html 10+ Power BI Interview Questions : ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Cozc9WNBRt4.html SQL Server Joins : ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-KTvYHEntvn8.html SQL Step by Step - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-uGlfP9o7kmY.html Software Architecture Interview Questions : ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-AtTgcbLOqMM.html Angular Step by Step Tutorial for Beginners : ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE--9VcW7MBDs8.html 25 Angular Interview Questions : ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE--jeoyDJDsSM.html 35 Important JavaScript Interview Questions : ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Zb4dPi7CANU.html 30 Important C# Interview Questions : ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-BKynEBPqiIM.html 25+ OOPS Interview Questions : ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-u99wAoBjDvQ.html 25 Important ASP.NET Interview Questions : ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-pXmMdmJUC0g.html 20 PHP Interview Questions : ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-1bpNSynUrl8.html 5 MSBI Interview Questions : ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-5E815aXAwYQ.html 20 MySQL Interview Questions : ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-9hfjC-BpY20.html

@questpondvideos 4 года назад

Angular, MVC core starting 16.07.20, Every Thursday at 9 PM. Syllabus explained in the video if needed the syllabus do email at questpond@questpond.com. If Interested share this video on your FB, Twitter, and Linkedin and avail today's training free. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-MblRRqld1fg.html

@mineispolson 4 года назад

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

@nareshar8237 7 лет назад

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

@AP-sb3vl 7 лет назад

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

@sidharthmandal9957 2 года назад

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?

@jonathanzuniga3681 10 лет назад

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

@questpondvideos 12 лет назад

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

@chandrageetham 2 года назад

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

@dnfvideo 11 лет назад

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

@manojtate9604 2 месяца назад

I loved it! The explanation was top-notch

@authoenthu 7 лет назад

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

@questpondvideos 8 лет назад

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 questpond@questpond.com with the shared link and we will email you the PDF.

@bharathreddygali 7 лет назад

Hello pls email me the interview questions

@vandanasuryawanshi2213 3 года назад

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

@prasunjeetsoni6143 5 лет назад

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 5 лет назад

Check this ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-HmnQyP8s5O8.html

@gplus46 7 лет назад

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

@narojunaresh8437 5 лет назад

Sir, Can you explain clustered and non clustered indexes?

@jyotibarasker2792 8 лет назад

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

@7to7media 5 лет назад

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

@RamSagarMourya 12 лет назад

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

@venkataprasadkistam2705 7 лет назад

beautiful and clear explaination thanks a lot

@hayat1410 12 лет назад

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

@donovan30081995 10 лет назад

Thank you so much for this video :)

@RibasFilms 9 лет назад

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

@fastdrive55 12 лет назад

Great video- summarizing the main points.

@fayechang8647 Год назад

Thanks it's really clear

@SuperFrankbob 7 лет назад

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

@digant83 8 лет назад

Very well explained. Thank you very much.

@udayakula3664 8 лет назад

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

@its_bijay_adhikari 5 лет назад

Thanks! Helped me alot to understand!!

@lovefor011 6 лет назад

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

@creativestatus9820 4 года назад

thanku

@pankajpatel2456 7 лет назад

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

@thisisgaurang 10 лет назад

Excellent sir !

@sanjeebamat4485 7 лет назад

thank you so much sir for explanation appreciate you.

@sureshborade5671 7 лет назад

Nice explanation ..

@ynevet 9 лет назад

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

@mohammedroshid7922 7 лет назад

Great job! Thanks a million

@laurarankin4663 8 лет назад

Thank you!

@nareshar8237 7 лет назад

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 ??????????

@itipriya9224 7 лет назад

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

@questpondvideos 7 лет назад

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

@chiggrens_playground3193 6 лет назад

Thank you very much, really appreciate!

@malayshah8421 7 лет назад

Really good explanation :)

@MrNoomiali 6 лет назад

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

@saispark4934 2 года назад

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

@nivethithanivetha921 4 года назад

What does logical reads means ????

@JanekBaranek 6 лет назад

Clever video, clever man ;)

@srikanthsurabhis 9 лет назад

Thank you

@JeraldJamesCapao 7 месяцев назад

Thank you. ^^

@ipsitapani8641 12 лет назад

Nice very nice tutorial

@Ganeshay-996 3 года назад

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

@questpondvideos 3 года назад

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

@ErJanardhanJethi 7 лет назад

How does it work in case of String search?

@mnatum-v17 8 лет назад

thanks

@ynevet 9 лет назад

well done!

@SurendraTarai 3 года назад

What is logical reads?

@archanasaini5227 7 лет назад

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

@ghanshamkashyup6235 3 года назад

So easy

@jayakottam 6 лет назад

Thank you, easy to understand

@lovefor011 6 лет назад

what is version of mssql managemnt studio?

@sagittariusguy2011 11 лет назад

Awsome!!!!

@mnatum-v17 8 лет назад

how can we sort nonclustered index ?

@questpondvideos 8 лет назад

+msstaui DB For Technical query mail us at questpond@questpond.com

@tyronesunde8314 6 лет назад

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

@krishan63 4 года назад

So past

@questpondvideos 6 лет назад

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

@kingsleyyetoh7283 5 лет назад

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

@rohith.mohansai 5 месяцев назад

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

@aksandesi1919 7 лет назад

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

@Censtudios 5 лет назад

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

@anilsthanam409 4 месяца назад

Excellent explanation

@showyou1197 2 года назад

Simple and awesome

@Kuraby 2 года назад

thank you!!

@prakashpasupathy1612 11 лет назад

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.

@rohitsotra2010 6 лет назад

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

@karankatam6684 3 года назад

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

@fatfati_wale 6 лет назад

i like way of explanation ..very helpful

@shivanishubham5575 6 лет назад

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

@maedehshahabi4744 4 года назад

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

@AkshayBopshetti27 4 года назад

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

@atvo2950 4 года назад

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

@soumenr2168 5 лет назад

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

@asifshaik5244 7 лет назад

Please explain the Clusterd and Non Clustered index

@AjaySingh-dr5ry 4 года назад

Nice language sir and topic explain also

@harmanpreetkaur5910 10 лет назад

Plz explain cursorcand sequences..

@sidhant251 5 лет назад

Which software are you using

@thingsinthebox 7 лет назад

clear and have code examples, very good !

@vison819 6 лет назад

perfect explanation about B-tree index

@bibigabuyo1654 4 года назад

Thank you for this, really helps a lot!

@danew637 10 лет назад

thanks for the video

@databaseknowledge465 4 года назад

Very well explained

@excessreactant9045 3 года назад

This was a great vid :)

@crummmycheese 10 лет назад

As always the best

@RahulKumar-vr4cm 6 лет назад

Microsoft Access.

@katiatkachenko5349 6 лет назад

thank you

@vipulshahi7552 8 лет назад

better

@ulysses1904 6 лет назад

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.

@gkmishra2009 5 лет назад

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

@digant83 8 лет назад

Do you have same DVD package for Java as well ?

@questpondvideos 8 лет назад

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

@ManuelJordan317 3 года назад

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

@saitejaaa1086 2 года назад

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