Thank you Saeed, is is a great tutorial, I have been looking for such a video for long time and I have learned few things from you today thank you very much. can you please make more video in this topics for example why we should use include columns and what is the best practice for indexing a query with multiple joins etc...
As per the video, you are retrieving data from ColB and ColC. SQL Server is then suggesting to create index for the same columns. Since, index for all three columns have been created, how to use the same index for the retrieving data for B and C not A and B?
It's not possible to use the same index (A,B,C) when we have a where clause B and C. the way that indexing works is like from left to write so only index used if these conditions: 1- .... where A 2- .... where A and B 3- .... where A and B and C
Indexing is very sensitive subject in sql server. Time to time we need to modify the index based on data increased. Thank you for valuable content.
Glad it was helpful! Thank you 🙏
Thank you Saeed, is is a great tutorial, I have been looking for such a video for long time and I have learned few things from you today thank you very much.
can you please make more video in this topics for example why we should use include columns and what is the best practice for indexing a query with multiple joins etc...
You are most welcome and thank you for the feedback, sure I will cover this topic in future videos
It was very helpful dear saeed ❤
Thanks a lot
Glad to hear that Arash jan❤️
Please make a separate video on execution plan in detail. Thanks in advance
Noted with thanks, stay tunned.
As per the video, you are retrieving data from ColB and ColC. SQL Server is then suggesting to create index for the same columns. Since, index for all three columns have been created, how to use the same index for the retrieving data for B and C not A and B?
It's not possible to use the same index (A,B,C) when we have a where clause B and C. the way that indexing works is like from left to write so only index used if these conditions:
1- .... where A
2- .... where A and B
3- .... where A and B and C