Understanding Aggregate Functions Performance | The Backend Engineering Show
from The Backend Engineering Show with Hussein Nasser Hosted by Hussein Nasser
Aggregate functions like Count, max, min, avg performance really depends on how did you tune your database for that kind of workload. Let us discuss this. 0:00 Intro 1:22 SELECT COUNT(*) 4:30 SELECT AVG(A) 5:15 SELECT MAX(A) 8:00 Best case scenario 11:30 Clustering 14:00 Clustering Sequential Writes 17:19 Clustering Random Writes 20:30 Summary
Embed this episode
No transcript yet.
Frequently asked questions
How long is this episode of The Backend Engineering Show with Hussein Nasser?
This episode is 23 minutes long.
When was this The Backend Engineering Show with Hussein Nasser episode published?
This episode was published on March 23, 2022.
Can I download this The Backend Engineering Show with Hussein Nasser episode?
Yes. Use the download control on the episode player to save the publisher-provided media file.