4 ms·
Anyone tried ChatGPT and Co yet to explain some EXPlAIN output and ask it for optimization suggestions?
by janpio 4y ago
Anyone tried ChatGPT and Co yet to explain some EXPlAIN output and ask it for optimization suggestions?
- never_inline 4y agoThis, exactly this, is what worries me about this industry.
- hnarn 4y agoYou’re worried about people being able to get better ideas on how to optimize their queries?
- kernx16 4y agoI'm a DBA. I found that in general, it was OK for pretty obvious things but sometimes it missed stuff such as: running a LIKE with wild card at the start, ie: "LIKE '%Luke%'". Running that wildcard in the start tends to make the optimizer do a full scan. Otherwise, it did okay. Just ensure you give ChatGPT the schema as well for its best suggestion.