Hi friends,
I have an application at a customer that I developed about one year ago. At that time I created many queries (SQL-SELECT statements) and use the Index Tuning Wizard to optimize them. Now, those same queries take too long, I now that's because the data in the tables have grown very much during these years so I had to copy each of the queries to the Query Analyzer and run on them the Wizard so those can be optimized to run much faster. Is there any way to accomplish that task programatically from Visual FoxPro or from SQL Server itself (by some job)? I would like to create an option in the application so that the user is able to optimize the queries whenever he feels those take too long after some time. In case it's not necessary to optimize the queries once in a while, I would like to know if I can optimize any query programatically, that is, without having to copy the query to the Query Analyzer and run on it the Index Tuning Wizard.
TIA
Luis