SQL Server Manteniance : Index and Statistics
I have been using BizAgi (with SQL Server) for a while, and lately i have found a lack of performance when executing some queries .SQL Server Management Studio provides an assistant to optimize the engine of the Data Base, and after launching in a test environment, it gives some recommendations (all based on creation of index an statistics). These recommendations include system tables (i.e. WFCASE , WFCASECL
, WORKITEM, WORKITEMCL)
My question is:
Is there any problem on launching these recommendations over a instance of SQL Server where BizAgi (9.08.03) is running?
Thanks in advance,