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

[@JayManoharVengurlekar]

Got to learn new things inserting 500 records too Thanks Mam doing grt job GOD Bless you got a new Subscriber :)

[@chandu9143]

Good 👍

[@ishwarmangapur324]

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

[@LearnWithMRajput]

Glad that it is helpful

[@gauravsuryawanshi1639]

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

[@nitagawade3330]

Nice video....thnk you!!!

[@LearnWithMRajput]

Glad that you find it useful

[@P5toraskar1986]

Good one Thank you.

[@bodoziada6242]

i can't see the output list in the screen

[@prasadbandi1995]

please make video on Team Foundation Server

[@LearnWithMRajput]

Will try definitely

[@ArunMaskeri]

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

[@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.