How Slow is SELECT * ? (A deep dive) | by Hussein Nasser | Apr, 2023 | Medium

In a row-store database engine, rows are stored in units called pages. Each page has a fixed header and contains multiple rows, with each…