I thinks this covers the ELI5 level pretty well.
If you want to dig deeper into indexing and how it works with a relational database I would absolutely recommend Use the index luke. Even from the 3 minute test I learnt something.
We're a place where coders share, stay up-to-date and grow their careers.
We strive for transparency and don't collect excess data.