3 ms·
Redshift with around 5TB of data (each row has ~ 30 columns)
by whatever1 2y ago
Redshift 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.