Hey everyone, it’s me
I’ve been taking the Design Databases with PostgreSQL skill path, and right now I’m in the Indexes section. I already finished the first lesson on indexes, but before moving on to what’s next I just wanna make sure I understood what an index is.
So, here goes my explanation:
An index is a data structure that helps you find data in your database faster. It basically takes all the values from the column you specify and uses them to create a binary tree structure. One of its cons is that it obviously takes up space, and it can increase the size of your database quite quickly. Also, whenever you perform a DELETE, UPDATE or INSERT statement that affects the values of the column(s) you defined an index for, the index will have to be completely reorganized, so it can slow down those processes.
Did I miss something? Did I get something wrong?
I’d truly appreciate some feedback