Scan or random reads
Difficulty 2 of 5
A query reads 16 MiB of rows from main memory. A sequential scan streams at 20 GB/s. An index lookup reads the same bytes as random 64-byte lines, one after another, and each line waits 100 ns for memory. How many ms do the random reads take?
The question
Answer with one number in ms.
Goals and limits
- Completion time
- under 40 ms
- Monthly cost
- under 1,000 USD/mo
Concepts
How players did
Player results load from the server.