database

B-Tree index structure

At some point we all worked with a relational database. We all had problems with query performance and we fixed them usually by first looking at indexes. We looked at the columns, at the foreign key for the presence of an index. We noticed there some kind of B-tree structure. Now I'm gonna explain how… Continue reading B-Tree index structure