[Aeolun]

It’s because it is just really expensive (both in time and money) to do basic things like a table scan.

[Dunedan]

That's actually one of the caveats that comes with unlimited scalability: You must design your application to not require full table scans.