Hacker News new | ask | show | jobs
by lesserknowndan 611 days ago
What exactly do you mean when you say "FROM database"?

If a "database" is a single table I would be surprised, however, if "database" is a view then potentially there is a lot that needs to go on under the hood to determine which 10 rows should be returned - particularly if something is doing a group by and cannot constrain it through any where constraints.