Should I cluster my data?
ฝัง
- เผยแพร่เมื่อ 11 ก.ย. 2024
- Attribute clustering is a cool feature that can supercharge query performance in your database. But are there downsides you need to be careful of?
Follow me!
blog: connor-mcdonal...
twitter: / connor_mc_d
The Podcast!
podcasts.apple...
open.spotify.c...
Subscribe for new tech videos every week
Other social media channels here: linktr.ee/connor
Music: Night Owl (Broke For Free), Kevin Mcleod (incomptech), Dyalla
#sql #database
Recently implemented attribute clustering on a 16 million row sales order table by date, and took one of our common query patterns from 10 seconds down to 5.
Lots of clustering is unnecessary by a Index scan if they are covering for those lists.
Index scans can still be incredibly slow for unclustered data
Thank you sir
Welcome