2 ms·
> Querying a single table with an indexed key will be faster as a single lookup than doing a JOIN, let alone several. Not always, particularly when you're retu
by Jweb_Guru 10y ago
> Querying a single table with an indexed key will be faster as a single lookup than doing a JOIN, let alone several.
Not always, particularly when you're returning multiple keys at once. Some comparisons with column stores would be instructive.