All About INDICES in SQL Databases | BTREE HASH GIN
FREE Java learning and interview preparation materials from me: https://t.me/JavaLearnBot?domain=Java...
To get a link to the GitHub code from the video, type "ANOTHER_MATERIALS" in the bot: https://t.me/JavaLearnBot?domain=Java...
My course on Java development and getting your first job: https://sorokin.school/?utm_source=yo...
Telegram channel: https://t.me/S0R0KlN
ㅤ
Databases can't quickly process search queries when there's a lot of data, and Over time, the amount of data in every system only grows. But indexes come to the rescue with this problem.
We'll look at common types of indexes found in real projects and also touch on their structure, when to use each, and whether it's necessary at all. The topic of indexes is quite important for all backend developers, which is why it's often asked in job interviews.
Timing
00:00 Start
00:51 Search Problem
05:24 BTree Index
11:52 BTree Example
14:09 Hash Index
19:16 Hash Example
20:10 GIN Index
22:45 GIN Example
25:22 Indexes aren't free
26:32 Let's get to practice
32:42 Indexes in real JAVA projects (example)
42:51 Extreme example. Significant slowdown.
46:35 Conclusion