Has anyone create something that will automate running the query optimizer for a particular table?
Ideas would be greatly appreciated.
Thank you,
Joe Genovese
Do you mean Update Statistics?
Yes, update statistics for the entire table autmatically. Do I need a special client to connect? Maybe a little java app?
It is a SQL client thing.
Yes, I am still looking for a batch method of updating the statistics with a sql client.
Yes, I am still looking for a batch method of updating the statistics with a sql client.
Not that I'm familiar with SQL92 at all, but
%DLC%\bin\sqlexp -db ... -S ... -H ... -char -infile yourscript.sql
should exactly allow you to do that in batch mode.
Mike,
Thank you, I will give this a try.
sqlexp -help will give you details about the parameters.