Table Scan Vs Index Scan Vs Index Seek in sql server | by SQL Training Sessions
Vložit
- čas přidán 19. 01. 2019
- 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 :)
Hello Madam,
i really cleared with the above concepts now...thank you
thanks for your all the videos those videos are really understanding and very helpfull.😊
Glad that it is helpful
Good 👍
Good one Thank you.
Nice video....thnk you!!!
Glad that you find it useful
I liked the vedio how you explained , but non clustered idx gave incorrect result
i can't see the output list in the screen
please make video on Team Foundation Server
Will try definitely
hi mam..can you explain in hindi?
When using the
select first_name from TBL_NC where id=5
we see table scan and you could not clarify that
Yup i have addressed as well .as you mentioned the query was returning table scan
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
exactly, i was wondering after watching like that
Concepts of speaker are not clear.. she needs more study..
Thanks for your valuable feedback.