Articles in this series
What's OLTP? OLTP stands for Online Transaction Processing, in which a database is used to execute huge amounts of transactions. Transaction means to...
Introduction Different applications have different requirements, as discussed in What the heck is OLTP, OLAP?, it depends on business rules to define...
Introduction It's well-known that the database's main bottleneck lies in I/O. That's what makes database designers aim toward reducing it in any...
Introduction In order to allow the database execution engine to perform its operations, it needs the pages containing the table records to be brought...
Introduction As explained in Database Buffer Pool - Part 1, a buffer pool is a limited chunk of memory, which means that whenever we bring something...
Why database indexes? When it comes to querying databases, one of the most time-consuming and performance-intensive operations is to do a linear scan...
