4 ms·
Could it be construed as a dumb question because the details depend on the specific engine you're using? If you have TABLESAMPLE, then the question is trivial.
by krackers 1y ago
Could it be construed as a dumb question because the details depend on the specific engine you're using? If you have TABLESAMPLE, then the question is trivial. The question doesn't really test anything general other than "are you aware that your engine probably already has a feature for this"
- wenc 1y agoI don’t think that in itself is dumb. It’s an application question that tests knowledge on sampling and doing it within the constraints of a database language and performance envelope of a large data store. The spirit of the question isn’t about the syntax but knowing the trade offs when applying sampling on a database.