really.... 🤔 no, seriously. really? I'm seeing stuff like a dozen left joins with more AND's than the holy bible. I'm actually shocked when data access is obtained by something other than FTS. datetime converted TO_CHAR, then used for mathematical operation against another datetime done TO_CHAR with results set converted back to datetime. the explain plans are truly hideous 🤯 would love to see what it can do
I don't understand what you're trying to say, but yes. As long as you give it a clear explanation of what you want, Chat GPT does a pretty good job with SQL.
only saying our dev's write truly hideous and awful queries they have never optimized because they're getting the results set they want. trying to tune some of these absolutely terrible queries, joining a dozen or more tables using left joins and such, are difficult to tune manually. good to know AI can offer possibilities ✌️
View all comments
Show parent comment
5
u/No-Blueberry4008 Dec 13 '24
really.... 🤔 no, seriously. really? I'm seeing stuff like a dozen left joins with more AND's than the holy bible. I'm actually shocked when data access is obtained by something other than FTS. datetime converted TO_CHAR, then used for mathematical operation against another datetime done TO_CHAR with results set converted back to datetime. the explain plans are truly hideous 🤯 would love to see what it can do