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


Explaining Key vs Non-Key Column Database Indexing and How it can Improve Performance
1.60 GEEK