3 ms·
Which database? In postgres, the limit query can sometimes result in poor performance if the table statistics are not kept up to date. You can run `ANALYZE tab
by perrygeo 2y ago
Which database?
In postgres, the limit query can sometimes result in poor performance if the table statistics are not kept up to date. You can run `ANALYZE tablename` to refresh the stats manually, but the autovacuum process should do this periodically if configured correctly.
- whatever1 2y agoRedshift with around 5TB of data (each row has ~ 30 columns)
- lesserknowndan 2y agoWhat 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.