Creating Covering Index to Eliminate Join - SQL in Sixty Seconds 090

[@hithomesolutions]

@PinalDaveSQLAuthority, I've been a SQL Server database developer for years, and I always learn something new from you. Thank you! --Scott W.

[@PinalDaveSQLAuthority]

Great to hear!

[@PatrickWard4]

I can't tell you how many times you blog posts have helped me in the past. Thank you for all that you do!

[@PinalDaveSQLAuthority]

You are very kind. Thank you.

[@eq2home]

PInal it has been a while. As always I smiled and learned something. Cheers

[@PinalDaveSQLAuthority]

Thanks!

[@kesavkick4537]

Mind blowing tricks sir...please keep on continue share this kind of tricks ...thank you...🤝

[@PinalDaveSQLAuthority]

Sure 👍

[@frankzelazko]

Pinal, you are a genius ! Cheers

[@PinalDaveSQLAuthority]

Thanks!

[@Gioandgoose]

Fantastic tip and explanation! Thank you for sharing.

[@PinalDaveSQLAuthority]

Thanks for watching!

[@habibrashid6065]

Thank You brother Pinal🙏 from 🇪🇹

[@PinalDaveSQLAuthority]

👍

[@mararbinu]

Thank you
Have a question here. why SQL not creating Keylookup here

[@PinalDaveSQLAuthority]

Once cover index is created keylookup goes away.

[@mararbinu]

Thanks Pinal.But my question was why key lookup not created before applying The covering index

[@Harshk2501]

Impressed by your knowledge sir. Pls keep sharing more performances tuning tricks. Please share more videos on how to understand the query plans and work on it

[@PinalDaveSQLAuthority]

Sure. Please watch many I have already created on this channel.

[@Harshk2501]

Pinal Dave Thank you Sir 😊

[@nutansharma800]

Great sir , it's very informative 👍

[@PinalDaveSQLAuthority]

So nice of you

[@arthurcoutinho9266]

Very good Pinal! Thanks a lot.

[@PinalDaveSQLAuthority]

Thanks for watching

[@bujinmasha6968]

Thank you so much ! Pinal. Learning from you the precious knowledge and skills. Please could you recommend your SQL book for the advanced and pro skills.

[@PinalDaveSQLAuthority]

Great suggestion!

[@carlosbaez2669]

Thanks for the explanation.

[@PinalDaveSQLAuthority]

Thanks for watching

[@erbasheer]

Nice one mate.. great stuff.

[@PinalDaveSQLAuthority]

Thank you so much!

[@Rishad-mj]

Will includes columns will cause additional overhead in any way, Especially while inserting and updating?

[@PinalDaveSQLAuthority]

Yes minor overhead.

[@himanish2006]

Pinal how much market demand is there for this new technology?

[@PinalDaveSQLAuthority]

Every technology has its demand.

[@himanish2006]

@@PinalDaveSQLAuthority I am learning .Ur advice ?

[@arunsingh2903]

Hi Pinal, what is the best practice to alter column of a table if table size is 2 TB? Regards, Arun

[@PinalDaveSQLAuthority]

This is indeed going to take time so there is no quick solution. You just have to find a time when there is not much activity for faster response.

[@arunsingh2903]

@@PinalDaveSQLAuthority Many thanks for your response .. i am very happy to receive your response :)..i am your big fan the way you explain.. this was my first post..

[@chetalikekre5668]

Just one request.. Could you please post a video that explains the entire execution plan?? Or if you already have a blog post on this could u pls share a link?

[@PinalDaveSQLAuthority]

The entire execution plan is an extremely long subject. Many days long. I will do my best to come up with a small series.

[@chetalikekre5668]

@@PinalDaveSQLAuthority That would be of great help.. Thank you in advance 🙏

[@ameyraj4947]

Awesome🎉🎉

[@PinalDaveSQLAuthority]

Thank you! Cheers!

[@a.useronly2266]

Thanks sir 👌🏻👌🏻👍🏻

[@PinalDaveSQLAuthority]

So nice of you

[@dennyjoppan]

is there any way to improve query performance when using order by , sort cost in execution plan always shows the highest percentage

[@PinalDaveSQLAuthority]

A good index can help there.

[@thiagosa84]

Lots of valuables insights, besides the main focus of the video

[@PinalDaveSQLAuthority]

Thanks for the kind words.

[@achilleskocaeli]

Excellent.

[@PinalDaveSQLAuthority]

Glad that you liked it.

[@Imrannaseem818]

many thanks Pinal.

[@PinalDaveSQLAuthority]

Thanks for watching

[@maheshd1838]

Thank you a lot !! Pinal

[@PinalDaveSQLAuthority]

Thanks so much

[@ivanb000]

Why you used "Included columns" instead of "Index Key Columns"? And what is the difference between them?

[@PinalDaveSQLAuthority]

I will use to create cover index and as they are not in key columns, they are not searchable. Also you can include certain datatypes in key column but in included columns you can have more. I will be creating live video on this topic next time.

[@ivanb000]

@@PinalDaveSQLAuthority Thanks a lot for the fast reply. Is there a recommended max number of columns to use in the "included columns"?

[@PinalDaveSQLAuthority]

@@ivanb000 Honestly it is all based on a schema. Not one number we can agree upon.

[@mandarhadke75]

Great tips Sir! Can we use this tip to improve query performance wherein multiple table joins are used? Please advise. Thanks in advance.

[@PinalDaveSQLAuthority]

This is a great topic. I will blog about it soon.

[@mandarhadke75]

@@PinalDaveSQLAuthority Thanks for your reply. Will look forward to this blog post! :)

[@JayPatel-uk2ms]

Please make a Video on Sql Profiler and table partitioning.

[@PinalDaveSQLAuthority]

Sure both are interesting subjects.

[@JayPatel-uk2ms]

@@PinalDaveSQLAuthority Thanks Pinal..))

[@SagarThakkar786]

nice..

[@PinalDaveSQLAuthority]

Thanks