4 ms·
Interesting, I tried to make a query taking a long time using join and got 37.43s: SELECT * FROM trips JOIN gas_prices ON gas_prices.timestamp = trips.
by DevoidSimo 6y ago
Interesting, I tried to make a query taking a long time using join and got 37.43s:
SELECT * FROM trips
JOIN gas_prices ON gas_prices.timestamp = trips.pickup_datetime;
- calibas 6y agoSeeing the same results on my end for that query. I'm a little puzzled, when I use the same query but with != instead of = to produce a 1.6 trillion row result, it's about 3-4ms execution. I don't know why it's taking 10,000x longer using = instead of !=. Something about how timestamp comparisons are handled?