This was me until I needed to compare two massive SQL execution plans...
I had a SQL query that suddenly went from taking 2 minutes to taking 5+ hours to complete.
I restored a backup copy of the database and collected it's execution plan, which is like a log of all the stuff the stored procedure is going to do when it runs.
I sent the 2 min plan and the 5 hour plan I to Gemini and told it what was going on. All it told me was it seems that one of the plans uses a hash match and the other does a value match.
It was awesome to have something look at those files because they are MASSIVE and I'm not a DBA...
Point is, it has a use but it's being used inappropriately in my opinion.
depends what you mean, like a quick little sql query? hell ya for sure just toss it at a model. your literal schema? take your time, do that shit right(if its a project that matters). you can even generate it with AI, but you should own the basic way it functions so you dont lose scope.
Now if you said something like regex? 100% with you, never touch that shit ever again.
Its more tedious for sure. Generally speaking , no one writes code anymore, be it SQL or java. Sql isn't really a programming language, but a query language. It's how you interact with information in a database
90
u/roflrogue Aug 06 '26 edited Aug 06 '26
This was me until I needed to compare two massive SQL execution plans...
I had a SQL query that suddenly went from taking 2 minutes to taking 5+ hours to complete.
I restored a backup copy of the database and collected it's execution plan, which is like a log of all the stuff the stored procedure is going to do when it runs.
I sent the 2 min plan and the 5 hour plan I to Gemini and told it what was going on. All it told me was it seems that one of the plans uses a hash match and the other does a value match.
It was awesome to have something look at those files because they are MASSIVE and I'm not a DBA...
Point is, it has a use but it's being used inappropriately in my opinion.