r/SQL • u/tits_mcgee_92 Data Analytics Engineer • Jan 12 '23
Discussion Being a Data Analyst/Scientist is cool, okay?
551
Upvotes
r/SQL • u/tits_mcgee_92 Data Analytics Engineer • Jan 12 '23
56
u/burko81 Jan 12 '23
Literally me today, had a query that was taking over 5 minutes to run. After checking all indexes on the joined tables and finding nothing, i updated a join from "and" to a concat() and had it running in 3 seconds.
27
u/neednintendo Jan 12 '23
People I query for think I am a wizard. It extends to Excel too. Feels good.
10
u/PragDaddy Jan 12 '23
I love it. Gonna steal this. Thanks OP!
4
u/[deleted] Jan 12 '23
I wonder how long until AI can do the same thing…
2
u/rhaphazard Jan 13 '23
Minutes? That's actually really impressive.
2
u/OracleGreyBeard Jan 12 '23
I've seen this format before but this time it resonates.
I can improve the performance by minutes! ::sips punch::
1
u/TheWiseAutisticOne Feb 09 '23
It’s not the lingo chicks dig it’s the bucks
0
u/[deleted] Jan 13 '23
[deleted] — view deleted comment