Is it necessary to use db_index=True in Django?

Question

Django

Hello! Learning the purpose of db_index came across the fact that it optimizes the search process.
But there are probably downsides, since it is not enabled by default.