In this video, I will explain the difference between Key vs Non-Key Column indexing and how adding a non-key column to your index can improve the performance.
0:00 Intro
3:00 No Index
5:30 Index with only key column
10:50 Index with key and non-key columns
#database