KarlE, 2 months ago

@nixCraft @isotopp in the late 1990s I had an SQL "select ... where a in (1,2,3)", there was an index on a. Using Informix it was fast. Using Oracle - why does this take so long? Turned out,
"a in <literal>" would just not use the index. Rewrote to generate "a=1 or a=2 or a=3" instead, and it ran... 🤦

isotopp, 2 months ago

@KarlE @nixCraft MySQL had a similar problem for "where a in ( <subs elect>)". This was fixed in 8.0 and is one of the many reasons to upgrade

hdante, 2 months ago

@nixCraft :KEKW:

nazokiyoubinbou, 2 months ago

@nixCraft omg the inflation. I remember not that long ago when commands were so much cheaper than this.

bitcointaske, 2 months ago

@nixCraft https://bitcointaske.com/?utm_medium=referral&utm_source=axm.am&utm_campaign=dzNBTTExMjI2OA__

lehrerseele, 2 months ago

@nixCraft

Just started teaching databases in 11th grade. Might come in handy. Thanks. :)

alter_unicorn, 2 months ago

@nixCraft 🤣