Answered

SQL Server Manteniance : Index and Statistics

Hello,

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,

photo
0

Dear Luis

A member of our support team will contact you.

Best regards.

Luis Emilio