That moment when you optimize something from taking ~10 minutes to ~17 seconds and are unsure if you managed to actually optimize that much or did you create a bug that doesn't return half the data...
Please let it be the former.

Related question; how do you measure performance when the same SQL query sometimes finishes in <10ms and other times takes more than 30 seconds? Same query, same data, same virtual server (although the host has a bunch of virtual machines, but this one is used by myself only).

Welp, I'm an idiot... Didn't notice a job running in the background that puts locks on the tables... Come on weekend, can you please hasten your arrival this week? I really need you...

@Bikonja 😂😂😂🤣 this is funny

@tisaconundrum yeah, will probably be to me as well in a few days :)

It's always a good feeling. I did the same thing today. I took an Oracle select query that was joining six different tables and returned a 96% optimization by adding two indexes. It feels really good.