To Index Or Not, That’s Not The Questions

Database indexes are useful. But how do they work? And how does one use them in Django?