How do Relational Databases Work Under the Hood?
- by Pierreten
I've always been interested in how you can throw some SQL at at database, and it nearly instantaneously returns your results in an orderly manner without thinking about it as anything other than a black box.
What is really going on?
I'm pretty sure it has something to do with how values are laid out regularly in memory, similar to an array; but aside from that, I don't know much else.
How is SQL parsed in a manner to facilitate all of this?