Start re-index as batch/scheduled job

teselink

Sometimes the performance in Axapta is very bad.
One of the solutions to solve this problem is re-index. (We are working with the Dutch version of Axapta and the job that has to be run is called "herindexeren"). A mouseclick on "re-index" will start the job immediately. Does anyone know if there is a possibility in Axapta to start re-index as a batch- or scheduled job? A solution to start something in the SQL manager I am not interested. The re-index has to be done in Axapta.
:whistle: One solution I have in mind. Use a database on Linux or OS/400. It is a pity that Axapta only supports Oracle and MS SQL Server.

Ionutz

From Main Menu click Administrator->Periodic->SQL Administration Form
-> Click Menu Item Button "Index Action" -> Choose Re-Index

teselink

Thanks for reply but I already know this action.
What I want is to run this action as a batch- or scheduled job.

kgaurav

solution of your problem lies with the class sysSqlAdminClass may be you can explore thrugh it.

Harish

Hi,

Usually it is not necessary to re-index on a regular basis.

As you may be aware, usually re-index is used to push any changes made to an index definition. Once an index is created, then SQL server/Oracle does a better job of handling index than the programmer.

Could you please elaborate on poor performance please.

Regards,

Harish Mohanbabu

Harish

Hi,

Forgot to mention this. You can run a re-index by using SqlDataDictionary class like -

static void Reindex(Args _args)
{
    SqlDataDictionary       sqldd;
    ;

    sqldd = new SqlDataDictionary();
    SQLDD.tableReindex();
}

You can try creating a batch class for the above job. For this, you might want to check this MSDN article -

http://msdn.microsoft.com/mbs/default.a ... singp1.asp

Hope this helps,

Harish Mohanbabu