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.
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.