Advantages and disadvantages of indexes in sql server Part 38

In this video we will learn about
1. Advantages and disadvantages of indexes
2. The types of queries that can benefit from indexes
3. Covering Queries

Text version of the video

Healthy diet is very important both for the body and mind. If you like Aarvi Kitchen recipes, please support by sharing, subscribing and liking our YouTube channel. Hope you can help.

Slides

All SQL Server Text Articles

All SQL Server Slides

All Dot Net and SQL Server Tutorials in English

All Dot Net and SQL Server Tutorials in Arabic

[salomonks-francais]

The only Expert who so far gives a better explanation in less 15 minutes, while others take 45 minutes to explain nothing.
So gifted KudVenkat, thanks for being a blessing for others.

[krzysztofs]

There are only advantages of your videos! Thank U Sir!

[AkshayaThirusangu]

You are a boon to the students like me who really want to understand the subject more clear and crisp. Thanks a ton @kudvenkat Blessed to have you on youtube!

[VenkyChalla]

THANK YOU FOR PROVIDING THE GREAT LEACTURES FOR THE CARRER GROWTH
ALL YOUR VIDEO SERIES WILL HELPS US FOR THE CARRER GROWTH

[williamwang]

There are only advantages of your videos! Thank U Sir! I'm watching like 100 videos of yours, and only thing I can say is other than excellent job.

[krismaly]

Revisiting to refresh my memory

Thanks a lot

[hostname]

Thank you for all your videos <3 The group by statement can benefit from the index but the index must be unique

[kirtim]

Liked Covering query explanation. Awesome!

[rajasekharreddy]

No words to say..I am a big fan of ur videos..superb..brother

[oiwah]

Thanks! I think I was already a bit late but still I Thank you for these videos!

[srinivaspulle]

Excellent - thanks a lot for information.

[MimiMimi-sikv]

thank you a lot it is really really help full

[ChaitanyaPaiTechie]

Thanks for clearing the disadvantages. So if the situation is like a query performance very low and also there are bulk inserts for the table then, to use a index or not to use is a question? What do you suggest for this?

[stutitehri]

Hi Venkat Sir, my question to you is that Indexes reduce performance; also there is clustered index applied in default.so is it required actually in real applications?

[bigdaddycool]

very good. Question: I know you have explained what covering query is and cluster index always covers a query. To me it sounds more like advantage rather than disadvantage. My question is how is covering query a disadvantage?

[maximshen]

I have the similar question as @Fahrettin Perçin, for non-clustered index, I assume coverying query is a plus, if there is no need to lookup in the table again. Could you confirm ? Because lookup in non-clustered table, you don't need to do extra lookup in original table, if there is nothing else info you need besides this non-clustered index itself.

[jonathanporter]

+Kudvenkat In your order by descending example, would you need to create a different index where salary is descending or did you mean that the order by can still use an index where salary is ascending and simply scan it in reverse order? Thank you in advance!

[sapnanayak]

How can we update an index? How to do index tuning? Please make a video on this. Thank you

[egl]

Thank you for these videos. Very helpful!
Quick question: This was probably mentioned at some point and I missed it, but, are indexes called upon automatically by a query? In other words, all I have to do is run a query and if there is an index that would help SQL automatically identifies that and uses it (ie: I don't have to mention the index in my query?)?

[bobbysugianto]

We can use NONCLUSTERED INDEX with INCLUDE columns for making a covering query right?