> The equivalent in a relational database would be writing a query without a where statement,

Sort of, though I'd say scan operations are typically more expensive in any RDMS.

The probably becomes when you want/need something more than the secondary index, then you gotta get more creative.