4 ms·

> what if there was a different query language with explicit index syntax.. There is, it's a feature in MySQL called Index Hints [1]. [1] https://dev.mysql.co

> what if there was a different query language with explicit index syntax.. There is, it's a feature in MySQL called Index Hints [1]. [1] https://dev.mysql.com/doc/refman/8.0/en/index-hints.html https://dev.mysql.com/doc/refman/8.0/en/index-hints.html

brianwawok 8y ago
Or oracle has it A DBA can even sit there as queries fly past, and add hints on the fly. And then you change a query from "select" (lowercase) to "SELECT" (uppercase), and query plans break and you break production. Fun times
- Matt3o12_ 8y ago
  Could you elaborate why changing select from lowercase to uppercase would break anything?
  - kimdotcom 8y ago
    Stored procedures where master and slave are on different OSs and/or case-sensitivity settings are not the same? Just a guess.