4 ms·
RDBMS platforms without function indexes means that some of these queries will force a row-by-row execution over your entire table. Enjoy running SELECT ... FR
by hotsauceror 6y ago
RDBMS platforms without function indexes means that some of these queries will force a row-by-row execution over your entire table. Enjoy running SELECT ... FROM a INNER JOIN b WHERE DATEPART(a.date, month) = b.whatever on a table with 500 million rows in it.
- paulryanrogers 6y agoThankfully even MySQL has them, at least as of version 8
- hotsauceror 6y agoYeah, I’m jealous of all the postgresql and MySQL people. SQL Server doesn’t have them and this kind of query would cause pain.
- branko_d 6y agoSQL Server can index a computed field, which is more-less the same thing.
- matwood 6y agoAs someone who used to use MSSQL extensively and is now forced into MySQL, trust me, do not be jealous of the MySQL people. 5.7 fixed some of the most egregious issues and 8.0 is adding some features, but the smoldering embers of the dumpster fire are still around.