Table Scan Vs Index Scan Vs Index Seek in sql server | by SQL Training Sessions

This session will help you understand following :
1. Table Scan vs Index Scan vs Index Seek
2. How these concepts affects the sql query performance.
3. Explain Actual Execution Plan
4. How to include actual execution plan in sql query
5. How to analyse sql query
Thanks for watching!
By sql Training Sessions
By SQL
Enjoy learning :)

[@ishwarmangapur324]

thanks for your all the videos those videos are really understanding and very helpfull.😊

[@LearnWithMRajput]

Glad that it is helpful

[@chandu9143]

Good 👍

[@gauravsuryawanshi1639]

Hello Madam,
i really cleared with the above concepts now...thank you

[@P5toraskar1986]

Good one Thank you.

[@nitagawade3330]

Nice video....thnk you!!!

[@LearnWithMRajput]

Glad that you find it useful

[@ArunMaskeri]

I liked the vedio how you explained , but non clustered idx gave incorrect result

[@bodoziada6242]

i can't see the output list in the screen

[@prasadbandi1995]

please make video on Team Foundation Server

[@LearnWithMRajput]

Will try definitely

[@dikshachawla2475]

hi mam..can you explain in hindi?

[@bodalarupesh5024]

When using the
select first_name from TBL_NC where id=5
we see table scan and you could not clarify that

[@anandprakash2478]

Yup i have addressed as well .as you mentioned the query was returning table scan

[@rohitkarnatakapu4760]

It still uses table scan because it has to go through all the records. However, if we add Fname in where condition, then it uses index-seek because the semi leaf nodes or the middle nodes have Fname

[@anandprakash2478]

exactly, i was wondering after watching like that

[@deepaksaraf7835]

Concepts of speaker are not clear.. she needs more study..

[@LearnWithMRajput]

Thanks for your valuable feedback.