 
      
    | You are here | planetscale.com | ||
| | | | | architecturenotes.co | |
| | | | | How Relational Databases Work. This post talks about how indexes and transactions work on the inside of relational databases. | |
| | | | | surfingcomplexity.blog | |
| | | | | I've been reading Alex Petrov's Database Internals to learn more about how databases are implemented. One of the topics covered in the book is a data structure known as the B-tree. Relational databases like Postgres, MySQL, and sqlite use B-trees as the data structure for storing the data on disk. I was reading along with... | |
| | | | | explainextended.com | |
| | | | | A late row lookup requires that the engine looks up a row in a table only if it had not been filtered by the index. MySQL is not capable of doing this but this can be emulated. It improves the LIMIT performance and filtering efficiency on the indexed fields | |
| | | | | www.interviewbit.com | |
| | | Table Of Contents show What is System Design? Best System Design Courses 1. Scaler Academy's System Design Course 2. Software Design and Architecture... | ||