3 ms·
> It allows people that don't know what they do to write queries that can significantly impact servers. At least for the only OLAP DB I use often - Amazon Reds
by scarface_74 1y ago
> It allows people that don't know what they do to write queries that can significantly impact servers.
At least for the only OLAP DB I use often - Amazon Redshift - that’s a solved problem with Workload Management Queues. You can restrict those users ability to consume too many resources.
For queries that are used for OLTP, I usually try to keep those queries relatively simple. If there is a reason for read queries that consume resources , those go to read replicas when strong consistently isn’t required