rick-v-ek.bsky.social
@rick-v-ek.bsky.social
Longtime Oracle DBA/DevOps but now retired.
Likes : Golf , Skiing , running and diy
Hates : Carrots.
Interests: Databases(oracle, postgresql, sqllite) ; linux (ublue), flatpacks, containers.
Opensource: tailscale, syncthing
Reposted
Timmermans on 🔥 vandaag
April 2, 2025 at 10:38 AM
Reposted
Golden performance oldie - approaching its tenth birthday. How to reduce run-time from 2 hours to 10 seconds by introducing an extra join to the big table:
jonathanlewis.wordpress.com/2015/04/15/c...
Cartesian join
Some time ago I pulled off the apocryphal “2 hours to 10 seconds” trick for a client using a technique that is conceptually very simple but, like my example from last week, falls outsid…
jonathanlewis.wordpress.com
March 20, 2025 at 9:51 AM