The Use of ReIndex in Ax 2009

Finance and Operations/AX Developer Forum
1

Hai all,

I seen one option in Ax 209

Microsoft Dynamics AX menu–>Tools–>Development Tools–>Application Objects -->ReIndex

What is the main use of the ReIndex .?

Plz Give me Suggestions & solutions

Thanks & Regards

2

Re Index is used to re-build the indexes - The Re-Index will drop the required indexes and creates the new indexes.

Re Building Indexes is a data base concept which can be done through AX.(by using Re-Index)

Indexes can become fragmented during data modifications. This fragmentation can become a source of performance.(The performance may effect)

One way of UN-fragmenting the indexes is done by Re-Building the indexes.

3

where can we create ClusterIndex