Re:Ask HN: Why sampling a database is not instantaneous?
by lesserknowndan on Tuesday October 08, 2024 @06:04PM
(#41782264)
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.
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.