Why we should not add index on every field in database?

Index maintain a data structure like B-Tree which needs to be updated every time a new insert is there, that column is updated or deleted. So, writes could be expensive and slow.

If you have doubts, want career advice, want help with assignment, help at job or anything related to tech.

Connect with me on a video/audio call:

15 mins(Free): https://bit.ly/3rNsoYA

15 mins($7): https://bit.ly/3rJ45Ls

30 mins($49): https://bit.ly/3xgBle4

60 mins($79): https://bit.ly/3zXMwKq

Instagram: https://bit.ly/2V9mgyf

Youtube Channel: https://bit.ly/3zYCzMS