That's what I'm going to do next. Be sure to tell it the metadata and relative number of rows in the tables involved.
You are viewing a single comment's thread from:
That's what I'm going to do next. Be sure to tell it the metadata and relative number of rows in the tables involved.
Like the name of the table/s, columns?
Sure and more importantly, the datatypes and any related stored procedures.
But I'm thinking, if you use a JOIN clause, but the table you're joining has fewer records than the table in the FROM clause, the AI might tell you to switch them. You could tell it that the FROM table has fewer records so it doesn't make that particular recommendation.
Ok, thanks .... obviously some work will be needed, but if we manage to make it work, so it can review code and make recomendations ....even some that are not a 100% on spot, but you can extrapolate from there, its still huge