What is Index Scan ,Index Seek and Table Scan?||SQLSERVER

[@bashabash3697]

Awesome bhai.. Shukriya..

[@sqliseasy]

Ty

[@bashabash3697]

@@sqliseasy what is the better way to check, whether the table or sp's are indexed or not?

[@sqliseasy]

Highlight table name or select .then press Alt + F1

[@melk48111]

wow.. awesome explanation

[@sqliseasy]

Thank you Melvis.

[@piyushtadas2001]

nice video Sir ji

[@sqliseasy]

Thanks and welcome

[@thevideoguru3059]

Nice explanation .your way of explanation is easy to understand.keep up the good work!

[@sqliseasy]

Thank you.

[@janhavighodake3997]

what is Unorderd covering non clustered index scan is there video
available

[@sqliseasy]

This is basically you are talking about scan operation on covering index i.e non clustered index .I have video on that .please check it out.
ruclips.net/video/yefP63XqlpY/видео.html

[@sqliseasy]

Is it helpful Janhavi!

[@pratikfutane8131]

Great explanation!!

[@sqliseasy]

Glad it was helpful!

[@AnilKumar-ot1eg]

Nice video on indexes...thanks for it

[@sqliseasy]

Thanks Anil.

[@darshanraw5264]

Supar 👍👍💯

[@sqliseasy]

thank you.

[@9876Ajit]

Super🙏

[@sqliseasy]

Thank you for your valuable feedback.

[@Ak20231]

Thanks!

[@sqliseasy]

You are welcome!

[@Shonuyadav6764]

Excellent explanation by taking a simple example. Thank you very much.

[@sqliseasy]

Glad you liked it

[@janhavighodake3997]

please create one video of one to one pivot and many to one pivot

[@sqliseasy]

Video is live.please check out

[@sqliseasy]

ruclips.net/video/qaLU7YH39kE/видео.html

[@saikiranp.r6966]

Nice video.
If we use the index key value then it is index seek, correct ?

[@sqliseasy]

Yes.

[@prashant.khodey]

What an explanations sir.. Thanks for make it simple. I realy like to subscribe

[@deepalisharma1327]

What do we mean by cost?

[@sqliseasy]

Time taken to complete operator execution.

[@sqliseasy]

Time taken to complete operator execution. If you are running query "select * from tablename" and if see execution plan for it. You will see different boxes. These boxes are called as operator and if you hover every operator you will see different matrices such as estimated cost , actual cost and many more.

[@aashishmangal6831]

Nice video in a simplified manner Thanks Shri

[@sqliseasy]

Thanks a lot Ashish .Please let me know if you want to create videos for you!!!

[@aashishmangal6831]

yes shri... can you give my your contact no

[@abhishekudri2570]

Nice explanation,,KEEP IT UP

[@sqliseasy]

Thanks Abhishek.

[@RalphNgOfficial]

thanks

[@Sriramuuu]

Great explanation. Thank you!

[@sqliseasy]

Thanks Sriram.

[@paninandan2233]

well said bro....

[@sqliseasy]

Thanks a lot +Pani for your feedback

[@apanaggarwal5503]

Nice one

[@sqliseasy]

+Apan Aggarwal Thanks

[@Delta46853]

nice video

[@sqliseasy]

Thanks Saul.

[@djhi-tek9249]

Haha indian accent

[@sqliseasy]

Its true!