What is the typical SSD read latency for indexed queries?

What is the typical SSD read latency for indexed queries?

• A. 1-5 ms.
• B. 10-20 ms.
• C. 50-100 ms.
• D. 0.5-1 ms.

Answer: (A)

When you look up data by an index, you’re typically performing a small, random read to fetch one or a few rows. SSDs handle these random accesses much faster than hard drives, so the observed time is in the low milliseconds range. That’s why indexed queries on SSDs commonly land around 1–5 ms. Cache effects can push even lower, but for a typical disk-backed path, this range is the practical expectation. Choose 0.5–1 ms would usually require being almost entirely in cache or an extremely optimized path, not the typical disk-backed case. Values like 10–20 ms or 50–100 ms imply heavier I/O, larger reads, or a return to HDD-like performance, which isn’t representative of standard SSD behavior for indexed lookups.

When you look up data by an index, you’re typically performing a small, random read to fetch one or a few rows. SSDs handle these random accesses much faster than hard drives, so the observed time is in the low milliseconds range. That’s why indexed queries on SSDs commonly land around 1–5 ms. Cache effects can push even lower, but for a typical disk-backed path, this range is the practical expectation.

Choose 0.5–1 ms would usually require being almost entirely in cache or an extremely optimized path, not the typical disk-backed case. Values like 10–20 ms or 50–100 ms imply heavier I/O, larger reads, or a return to HDD-like performance, which isn’t representative of standard SSD behavior for indexed lookups.